TD_VectorDistance (
ON { table | view | (query) } AS TargetTable PARTITION BY ANY
[ ON { table | view | (query) } AS ReferenceTable DIMENSION ]
USING
TargetIDColumn ('target_id_column')
TargetFeatureColumns ({ 'target_feature_column' | target_feature_Column_range }[,...])
[ RefIDColumn ('ref_id_column') ]
[ RefFeatureColumns ({ 'ref_feature_column' | ref_feature_Column_range }[,...]) ]
[ DistanceMeasure ({ 'Cosine' | 'Euclidean' | 'Manhattan'}[,...]) ]
[ TopK(integer_value) ]
)
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement