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
sql
ParameterTypeRequiredDescription
array1ARRAY<DOUBLE>YesFirst vector (array of doubles)
array2ARRAY<DOUBLE>YesSecond vector (array of doubles)

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
Suggest changes to this page
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19