SQL Call
SELECT * FROM VectorDistance (
ON target_mobile_data AS target PARTITION BY UserID
ON target_mobile_data AS ref DIMENSION
USING
TargetIDColumns ('UserID')
TargetFeatureColumn ('Feature')
TargetValueColumn ('value1')
DistanceMeasure ('Euclidean')
InputTablesSame ('true')
) AS dt ORDER BY 1,2;
Output
target_userid | ref_userid | type | distance
---------------+------------+-----------+-------------------
1 | 1 | euclidean | 0
1 | 2 | euclidean | 0.616414393881492
1 | 3 | euclidean | 1.4141900053772
1 | 4 | euclidean | 0.223828810912654
2 | 1 | euclidean | 0.616414393881492
2 | 2 | euclidean | 0
2 | 3 | euclidean | 0.812403825056265
2 | 4 | euclidean | 0.529244746229134
3 | 1 | euclidean | 1.4141900053772
3 | 2 | euclidean | 0.812403825056265
3 | 3 | euclidean | 0
3 | 4 | euclidean | 1.2767536832373
4 | 1 | euclidean | 0.223828810912654
4 | 2 | euclidean | 0.529244746229134
4 | 3 | euclidean | 1.2767536832373
4 | 4 | euclidean | 0