VectorDistance Example 2: Nondefault Thresholds - Teradata Vantage

This example uses the MaxDistance argument to limit the output to target vectors within the specified distances for each measure.

SQL Call

SELECT * FROM VectorDistance (
  ON target_mobile_data AS target PARTITION BY UserID
  ON ref_mobile_data AS ref DIMENSION
  USING
  TargetIDColumns ('UserID')
  TargetFeatureColumn ('Feature')
  TargetValueColumn ('value1')
  DistanceMeasure ('Cosine', 'Euclidean', 'Manhattan')
  MaxDistance (0.03, 0.8, 1.0)
) AS dt ORDER BY target_userid;

Output

Only UserID 2 and UserID 3 meet the threshold criteria.