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