Skip to Content
0

Issue in SQL Query - Instantiation of calculation model failed

Apr 05 at 03:25 PM

51

avatar image

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

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

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

Which studio and hana db version are you working on?

0

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

0
Shireesha Kandukoori
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

Thank you Shireesha,still its the same issue.

0