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
    -- 3-4-5 triangle hypotenuse length
    f1 := EUCLIDEAN_DISTANCE(
        ARRAY(0.0e0, 3.0e0, 4.0e0),
        ARRAY(0.0e0, 0.0e0, 0.0e0)
    )
;