VECTOR_EUCLIDEAN_DISTANCE

Returns the Euclidean distance, or L2 distance, between two vectors. The Euclidean distance measures the shortest distance between two points in space along a straight line. It is calculated by summing the squared distances of a pair of vector elements, and then taking the square root. Alias: l2_distance (aligned with pgvector for compatibility)

Syntax

VECTOR_EUCLIDEAN_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 Euclidean distance between two vectors:

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

distance double
2.8284271247461903

Rows: 1Execution time: 5.23ms

VECTOR_COSINE_SIMILARITY

VECTOR_INNER_PRODUCT

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

VECTOR_EUCLIDEAN_DISTANCE