TD_VectorDistance Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
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.