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' | 'DotProduct' | 'minkowski' }[,...]) ]
[ TopK(integer_value) ]
[ PValue(integer_value) ]
[ SearchThresholds(float_value[,...]) ]
[ LargeReferenceInput({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
[ OutputSimilarity({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
[ EmbeddingSize(integer_value) ]
[ SkipSelfNeighbor({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
[ UseSIMD({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})]
)
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