Version 1.1
SELECT * FROM VectorDistance ( ON target_input_table AS target PARTITION BY target_id_column [,...] ON ref_input_table AS ref DIMENSION TargetIDColumns ({ 'target_id_column' | 'target_id_column_range' }[,...]) TargetFeatureColumn (feature_column) [ TargetValueColumn (value_column) ] [ RefIDColumns ({ 'ref_id_column' | 'ref_id_column_range' }[,...]) [ RefTableSize ({ 'SMALL' | 'LARGE' }) ] [ RefFeatureColumn (feature_column) ] [ RefValueColumn (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' [,...]) ] );