COSINE_SIMILARITY (Lakehouse v2)
返回两个数组(向量)之间的余弦相似度。
Analyze 语法
Section titled “Analyze 语法”func.cosine_similarity(<array1>, <array2>)Analyze 示例
Section titled “Analyze 示例”func.cosine_similarity([1.0, 2.0], [2.0, 4.0])
┌─────┐│ 1.0 │└─────┘SQL 语法
Section titled “SQL 语法”COSINE_SIMILARITY(<array1>, <array2>)SQL 示例
Section titled “SQL 示例”SELECT COSINE_SIMILARITY([1.0, 2.0], [2.0, 4.0]);
┌─────┐│ 1.0 │└─────┘