SAP HANA 模糊查询(SAP HANA SQL Function Fuzzy search)

SAP HANA 模糊查询:具有快速和容错搜索的特征

支持模糊查询的数据类型(列存储)：

TEXT

SHORTTEXT 
VARCHAR, NVARCHAR 
DATE 
所有具有 full-text 索引的数据类型。

 

SELECT SCORE() AS score, *
FROM documents
WHERE CONTAINS(doc_content, 'Driethanolamyn', FUZZY(0.8))
ORDER BY score DESC;

 

SELECT SCORE() AS score, *
FROM documents
WHERE CONTAINS(doc_content, 'Driethanolamyn', FUZZY)
ORDER BY score DESC;

 

SELECT SCORE() AS score, *
FROM documents
WHERE CONTAINS(doc_content, 'Driethanolamyn', FUZZY(0.8,
'option1=value1, option2=value2'))
ORDER BY score DESC;