入力
入力テーブルは、StringSimilarityの例: 列名の指定にあるようにstrsimilarity_inputです。
SQL呼び出し
SELECT * FROM StringSimilarity (
ON strsimilarity_input PARTITION BY ANY
USING
ComparisonColumnPairs ('jaro (src_text1, tar_text) AS jaro1_sim',
'LD (src_text1, tar_text) AS ld1_sim',
'n_gram (src_text1, tar_text, 2) AS ngram1_sim',
'jaro_winkler (src_text1, tar_text, 0.1) AS jw1_sim'
)
CaseSensitive ('true')
Accumulate ('[0:1]', 'tar_text')
) AS dt ORDER BY id;