⌘+k ctrl+k
1.4 (stable)
Search Shortcut cmd + k | ctrl + k
Array Functions

All LIST functions work with the ARRAY data type. Additionally, several ARRAY-native functions are also supported.

Array-Native Functions

Function Description
array_cosine_distance(array1, array2) Computes the cosine distance 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.
array_cosine_similarity(array1, array2) 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.
array_cross_product(array, array) Computes the cross product of two arrays of size 3. The array elements can not be NULL.
array_distance(array1, array2) Computes the distance 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.
array_dot_product(array1, array2) Alias for array_inner_product.
array_inner_product(array1, array2) Computes the inner product 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.
array_negative_dot_product(array1, array2) Alias for array_negative_inner_product.
array_negative_inner_product(array1, array2) Computes the negative inner product 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.
array_value(arg, ...) Creates an ARRAY containing the argument values.

array_cosine_distance(array1, array2)

Description Computes the cosine distance 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.
Example array_cosine_distance(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result 0.007416606

array_cosine_similarity(array1, array2)

Description 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.
Example 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))
Result 0.9925834

array_cross_product(array, array)

Description Computes the cross product of two arrays of size 3. The array elements can not be NULL.
Example array_cross_product(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result [-1.0, 2.0, -1.0]

array_distance(array1, array2)

Description Computes the distance 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.
Example array_distance(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result 1.7320508

array_inner_product(array1, array2)

Description Computes the inner product 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.
Example array_inner_product(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result 20.0
Alias array_dot_product

array_negative_inner_product(array1, array2)

Description Computes the negative inner product 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.
Example array_negative_inner_product(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT))
Result -20.0
Alias array_negative_dot_product

array_value(arg, ...)

Description Creates an ARRAY containing the argument values.
Example array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT)
Result [1.0, 2.0, 3.0]
© 2025 DuckDB Foundation, Amsterdam NL
Code of Conduct Trademark Use