1. Oracle AI Vector Search User's Guide
  2. Use SQL Functions for Vector Operations
  3. Vector Distance Functions and Operators
  4. JACCARD_DISTANCE

JACCARD_DISTANCE

JACCARD_DISTANCE is a shorthand version of the VECTOR_DISTANCE function that calculates the jaccard distance between two vectors. It takes two BINARY vectors as input and returns the distance between them as a BINARY_DOUBLE.

Syntax


Description of jaccard_distance_syntax.eps follows
Description of the illustration jaccard_distance_syntax.eps

Parameters

  • expr1 and expr2 must evaluate to BINARY vectors and have the same number of dimensions. If either expression is not a BINARY vector, an error is raised.

  • JACCARD_DISTANCE returns NULL if either expr1 or expr2 is NULL.

Parent topic: Vector Distance Functions and Operators