Skip to Content
0

Issue in SQL Query - Instantiation of calculation model failed

Apr 05 at 03:25 PM

85

avatar image
Former Member

Hi All,

Facing issue in execution of below query based on caluclation view TEST_SEARCH in Test package

select MAKTX from "Test::TEST_SEARCH" WHERE CONTAINS("MAKTX",'Petrol',FUZZY(0.7)) LIMIT 10;

or

select MAKTX from "_SYS_BIC"."Test/TEST_SEARCH" WHERE CONTAINS("MAKTX",'Petrol',FUZZY(0.7)) LIMIT 10;

Both the queries fails with the below message

rror: (dberror) 2048 - column store error: column store error: search table error: [34023] Instantiation of calculation model failed;exception 306100: Text search is not supported

Any help how to solve this issue will be helpful

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagaraj G Apr 05 at 09:08 PM
0

Hi Mohan,

What is the data type of the column MAKTX ?

Fuzzy search is not supported if the column is of type LOB. You need to create FullText Index on the column in case if you want to use fuzzy search.

Regards,

Nag

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Nagraj,

Data Type is MAKTX.

0

MAKTX is not data type, its column name.

I did run the fuzzy search directly on table and I don't face such error

I am using HANA 2.0(SP02).

can you please post column definition from view ?

Moreover I see you have mentioned Quote 2 times in your query, it should be one time

select MAKTX from""_SYS_BIC"."Test/TEST_SEARCH"" WHERE CONTAINS("MAKTX",'Petrol',FUZZY(0.7)) LIMIT 10;

Regards,

Nagaraj

scn.jpg (27.3 kB)
0
Former Member

Hi Nagraj,

Sorry ,it was typo

Datatype of MAKTX is NVARCHAR.I checked by removing quote and its the same error.

https://help.sap.com/viewer/691cb949c1034198800afde3e5be6570/2.0.01/en-US/9a4da8f6f23b4ebf95c98f1104a56db4.html

The above document says the contains predicate is not supported in caluclation views. I am surprised to see that it works for you.

Thank you

0
Former Member
Former Member

Which studio and hana db version are you working on?

0
Former Member

I use web-based development workbench and HANA version is SPS 12

0
avatar image
Former Member
Apr 05 at 06:16 PM
0

Hi Mohan,

Can you try below query? I tried a similar query, it worked for me

select MAKTX from "_SYS_BIC"."Test/TEST_SEARCH" WHERE CONTAINS("MAKTX",'Petrol',FUZZY(0.7)) LIMIT 10;

Regards,

Shireesha


fuzzy.jpg (30.0 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you Shireesha,still its the same issue.

0