inner_product
Computes sum_i a_i * b_i over two equal-length array(float64) embeddings encoded as JSON-array text. Length mismatch yields NULL. For maximum-inner-product ANN ordering, use negative_inner_product …
inner_product(…) → Float64Kind · scalar
Computes sum_i a_i * b_i over two equal-length array(float64) embeddings encoded as JSON-array text. Length mismatch yields NULL. For maximum-inner-product ANN ordering, use negative_inner_product so smaller sorts first.
Part of the Vector family.
dot_product
Computes sum_i a_i * b_i over two equal-length array(float64) embeddings encoded as JSON-array text. Length mismatch yields NULL. For maximum-inner-product ANN ordering, use negative_inner_product …
l2_distance
Computes sqrt(sum_i (a_i - b_i)^2) over two equal-length array(float64) embeddings encoded as JSON-array text. Range [0, inf). Length mismatch yields NULL.