VECTOR_COSINE_DISTANCE

Returns the cosine distance between two vectors, calculated based on the angle (θ) between them. Vector cosine distance emphasizes the directional difference between the vectors, rather than magnitude. It is calculated as 1 - cos(θ), where cos(θ) is the cosine similarity between the vectors. VECTOR_COSINE_DISTANCE returns a value in the range [0, 2]. A vector cosine distance of 0 means that the vectors are identical in direction. A distance of 1 means that they are orthogonal and have no correlation. A distance of 2 means that they point in opposite directions. Alias: cosine_distance (aligned with pgvector for compatibility)

Syntax

VECTOR_COSINE_DISTANCE(<array>, <array>)

Parameters

Parameter	Description	Supported input types
`<array>`	The first array used in the distance calculation.	Any array of numeric data types.
`<array>`	The second array used in the distance calculation.	Any array of numeric data types.

Notes

Both input array arguments must have the same number of elements.

Return Type

DOUBLE

Examples

Example The following code returns the cosine distance between two vectors:

SELECT VECTOR_COSINE_DISTANCE([1, 2], [3, 4]) AS distance;

distance double
0.01613008990009257

Rows: 1Execution time: 5.26ms

VECTOR_ADD

VECTOR_COSINE_SIMILARITY

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

VECTOR_COSINE_DISTANCE