SELECT * FROM VectorDistance ( ON target_mobile_data AS target PARTITION BY UserID ON ref_mobile_data AS ref DIMENSION TargetIDColumns ('UserID') TargetFeatureColumn ('Feature') TargetValueColumn ('Value') DistanceMeasure ('Cosine', 'Euclidean', 'Manhattan') ) ORDER BY Target_UserID;