TD_VectorDistance Syntax Elements - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢
TargetIDColumn
Specify the target table column name that contains identifiers of the target table vectors.
TargetFeatureColumns
Specify the target table column names that contain features of the target table vectors.
You can specify up to 2018 feature columns.
RefIDColumn
[Optional] Specify the reference table column name that contains identifiers of the reference table vectors.
RefFeatureColumns
[Optional] Specify the reference table column names that contain features of the reference table vectors.
You can specify up to 2018 feature columns.
DistanceMeasure
[Optional] Specify the distance type to compute between the target and the reference vector:
  • Cosine: Cosine distance between the target vector and the reference vector.
  • Euclidean: Euclidean distance between the target vector and the reference vector.
  • Manhattan: Manhattan distance between the target vector and the reference vector.
TopK
[Optional] Specify the maximum number of closest reference vectors to include in the output table for each target vector. The value k is an integer between 1 and 100. The default value is 10.