Version 1.3
SELECT * FROM VectorDistance (
ON target_input_table AS TargetTable PARTITION BY target_id_column [,...]
ON ref_input_table AS ReferenceTable DIMENSION
USING
TargetIDColumns ({ 'target_id_column' | target_id_column_range }[,...])
TargetFeatureColumn ('target_feature_column')
[ TargetValueColumn ('target_value_column') ]
[ RefIDColumns ({ 'ref_id_column' | ref_id_column_range }[,...])
[ RefTableSize ({ 'SMALL' | 'LARGE' }) ]
[ RefFeatureColumn ('ref_feature_column') ]
[ RefValueColumn ('ref_value_column') ]
[ DistanceMeasure ({ 'cosine' | 'euclidean' | 'manhattan' | 'binary' }[,...])]
[ IgnoreMismatch ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
[ ReplaceInvalid ({ 'PositiveInfinity' |'NegativeInfinity' | custom })]
[ TopK (k) ]
[ MaxDistance (threshold [,...]) ]
) AS alias;