JACCARD_DISTANCE

JACCARD_DISTANCE(vector1, vector2);

Description

Computes the Jaccard Distance between two vectors. Jaccard distance is defined as 1 - Jaccard similarity coefficient, used to measure the degree of difference between two sets. For binary vectors, Jaccard distance = 1 - |A∩B| / |A∪B|, where A and B represent the sets of non-zero elements in the two vectors respectively.

Parameter Description

• vector1: The first vector, supported type vector\<tinyint>
• vector2: The second vector, supported type vector\<tinyint>

Return Result

Returns a double value in the range [0, 1]. 0 indicates the two vectors are identical, 1 indicates they are completely different.

Examples

• Compute the Jaccard distance between two vector\<tinyint> vectors

SELECT JACCARD_DISTANCE(VECTOR(1y, 0y, 1y), VECTOR(1y, 1y, 0y)) as jaccard_dis; +----------------------+ | jaccard_dis | +----------------------+ | 0.6666666269302368 | +----------------------+

• Compute the Jaccard distance between longer tinyint vectors

SELECT JACCARD_DISTANCE(VECTOR(1y, 0y, 1y, 0y), VECTOR(1y, 0y, 0y, 1y)) as jaccard_dis; +----------------------+ | jaccard_dis | +----------------------+ | 0.6666666269302368 | +----------------------+

• Compute the Jaccard distance between identical vectors (result is 0)

SELECT JACCARD_DISTANCE(VECTOR(1y, 1y, 0y), VECTOR(1y, 1y, 0y)) as jaccard_dis; +-------------+ | jaccard_dis | +-------------+ | 0 | +-------------+