EUCLIDEAN_DISTANCE()

All functions > ARRAY > EUCLIDEAN_DISTANCE()

Calculates the Euclidean distance between two arrays.

Signatures

Returns: Euclidean distance between the two vectors

EUCLIDEAN_DISTANCE(array1: ARRAY<DOUBLE>, array2: ARRAY<DOUBLE>) → DOUBLE

Notes

• Computes L2 distance between two vectors
• Formula: sqrt(sum((x[i] - y[i])^2))
• Arrays must be same length
• Used in ML, clustering, and similarity calculations

See also

• Array functions

Examples

SELECT
    f1 := EUCLIDEAN_DISTANCE(ARRAY(0.0E0, 3.0E0, 4.0E0), ARRAY(0.0E0, 0.0E0, 0.0E0)) -- 3-4-5 triangle hypotenuse length
;