COSINE_SIMILARITY_NORM (Lakehouse v2)

Returns the cosine similarity between two normalized arrays.

Analyze Syntax

func.cosine_similarity_norm(<array1>, <array2>)

Analyze Examples

func.cosine_similarity_norm([0.6, 0.8], [0.8, 0.6])

┌──────┐
│ 0.96  │
└──────┘

SQL Syntax

COSINE_SIMILARITY_NORM(<array1>, <array2>)

SQL Examples

SELECT COSINE_SIMILARITY_NORM([0.6, 0.8], [0.8, 0.6]);

┌──────┐
│ 0.96  │
└──────┘