Reference material for VECTOR_SQUARED_EUCLIDEAN_DISTANCE function
Returns the squared Euclidean distance, or squared L2 distance between two vectors. The squared Euclidean distance measures how far apart two vectors based on the size of their differences, without considering direction. By squaring the difference, it emphasizes larger differences, which can help in finding outliers or large deviations.
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. |
Both input array
arguments must have the same number of elements.
DOUBLE
Example
The following code returns the squared Euclidean distance between two vectors:
Returns
distance (DOUBLE PRECISION) |
---|
8 |
Example
The following code returns the squared Euclidean distance between two identical vectors:
Returns
distance (DOUBLE PRECISION) |
---|
0 |
Example
The following code returns the squared Euclidean distance between two vectors that are very far apart:
Returns
distance (DOUBLE PRECISION) |
---|
162 |