Lists & arrays Scalar

array_cosine_similarity()

Computes the cosine similarity between two arrays of the same size. The array elements can not be NULL. The arrays can have any size as long as the size is the same for both arguments.

Arguments & returns

2 overloads

`array_cosine_similarity(array1, array2)`

Scalar

Overload link	`array1`	`array2`	Returns
#01	`DOUBLE[ANY]`	`DOUBLE[ANY]`	`DOUBLE`
#02	`FLOAT[ANY]`	`FLOAT[ANY]`	`FLOAT`

Example

SELECT array_cosine_similarity(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT));

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3