SAP HANA Json Document Store and Fuzzy Search

[former_member527468]

Hiello Experts,

Does the JSON Document store support creating text index and doing a fuzzy search? We have a requirement where we are considering converting large denormalized tables with dynamic structure to JSON Document store collections. However, I could not find any information about how we can do a a fault tolerant search on JSON documents.

Is this planned, if it is not available currently?

Thanks in Advance,

Ajith

[lsubatin]

Hi, Ajith,

This is currently not supported. When attempting such a thing, I ended up moving the text to column store where I can perform those operations: https://blogs.sap.com/2018/07/13/friday-13th-for-sap-hana-json-is-here/

Best,

Lucia.