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 …
dot_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.
Aliases · inner_product
Part of the Vector family.
cosine_similarity
Computes 1 - dot(a, b) / (||a|| * ||b||) over two equal-length array(float64) embeddings encoded as JSON-array text. Range [0, 2]: 0 = identical direction, 1 = orthogonal, 2 = opposite. Length mism…
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 …