Vector Distance Functions

Databend provides functions for measuring distance or similarity between vectors, essential for vector search and machine learning applications.

Function Comparison

Function	Description	Range	Best For	Use Cases
L2_DISTANCE	Euclidean (straight-line) distance	[0, ∞)	When magnitude matters	• Image similarity • Geographical data • Anomaly detection • Feature-based clustering
COSINE_DISTANCE	Angular distance between vectors	[0, 1]	When direction matters more than magnitude	• Document similarity • Semantic search • Recommendation systems • Text analysis