Functions/Lists & arrays/array_dot_product
Lists & arrays Scalar

array_dot_product()

Compute 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.

Alias of array_inner_product()

Arguments & returns

2 overloads

array_dot_product(array1, array2)

Scalar
Overload link array1array2 Returns
#01 DOUBLE[ANY]DOUBLE[ANY] DOUBLE
#02 FLOAT[ANY]FLOAT[ANY] FLOAT

Example

array_dot_product example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  array_inner_product([1, 2, 3], [1, 2, 3]);