VectorDistance Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Output Table Schema for OutputFormat ('SPARSE')

Column Data Type Description
target_target_id_column Same as in TargetTable [Column appears once for each specified target_id_column.] All or part of target vector identifier.
ref_ref_id_column Same as in ReferenceTable [Column appears once for each specified ref_id_column.] All or part of reference vector identifier.
type VARCHAR Distance measurement type.
distance DOUBLE PRECISION Distance between target vector and reference vector.

Output Table Schema for OutputFormat ('DENSE')

Column Data Type Description
target_target_id_column Same as in TargetTable [Column appears once for each specified target_id_column.] All or part of target vector identifier.
ref_ref_id_column Same as in ReferenceTable [Column appears once for each specified ref_id_column.] All or part of reference vector identifier.
binary_distance DOUBLE PRECISION Binary distance between target vector and reference vector.
cosine_distance DOUBLE PRECISION Cosine distance between target vector and reference vector.
euclidean_distance DOUBLE PRECISION Euclidean distance between target vector and reference vector.
manhattan_distance DOUBLE PRECISION Manhattan distance between target vector and reference vector.