cosine_distance

cosine_distance

description

Syntax

DOUBLE cosine_distance(ARRAY<T> array1, ARRAY<T> array2)

Calculates the cosine distance between two vectors (the values of the vectors are the coordinates). Return NULL if input array is NULL or any element of array is NULL.

Notice

• nested type of input array support: TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE
• input array1 and array2 should have the same element size

example

sql> SELECT cosine_distance([1, 2], [2, 3]);
+-------------------------------------------+
| cosine_distance(ARRAY(1, 2), ARRAY(2, 3)) |
+-------------------------------------------+
|                     0.0077221232863322609 |
+-------------------------------------------+

keywords

COSINE_DISTANCE,DISTANCE,COSINE,ARRAY