SAP HANA - Fuzzy search

[Former Member]

Dear All,

Can i implement Fuzzy search over a column using HANA models? If so, please guide me on this.

Thanks and Regards,

Akshay

Message was edited by: Tom Flanagan

[Former Member · Accepted solution]

Hi Akshay,

Yes, you can fetch more column base on fuzzy search, but fuzzy search is only available for column tables and attribute views and supports the following SQL types and column store types,

VARCHAR,NVARCHAR,SHORTTEX,TEXT,DATE and FULLTEXT INDEX.

Example SQL:

SELECT SCORE(), ... FROM tab WHERE CONTAINS((col1, col2, col3), 'a b c', FUZZY(0.8));

Besides, If you need to use it in analytic and calculation views, you need to set freestyle search to true on attribute properties configuration.

You can reference below link to check detail information for fuzzy search from page 402.

http://help.sap.com/hana/SAP_HANA_Developer_Guide_en.pdf

Regards,

Jerry

[former_member184871]

Hi Akshay,

For Fuzzy search on SAP HANA you can also refer to Fuzzy Text Search | SAP HANA

Regards

Kumar

[vijay_simha3]

Helo Kumar,

I am  new to SAP HANA. I am not able to access the link which you provided. can you please update with document again.

Regards,

Vijay..

[rama_shankar3]

Akshay,

Please refer to this blog for details on how to implement fuzzy search. Its a good step-by-step.

http://scn.sap.com/community/developer-center/hana/blog/2012/10/10/the-not-so-fuzzy-fuzzy-search

Good luck! Hope this helps.

Rama