Skip to main content

Array Functions

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

Array-Native Functions​

FunctionDescription
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] |