Skip to Content
avatar image
Former Member

Issue in SQL Query - Instantiation of calculation model failed

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 05 at 09:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    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

    Add comment
    10|10000 characters needed characters exceeded