VectorDistance Example: Sparse I/O, InputTablesSame ('true') | Teradata Vantage - VectorDistance Example: Sparse-Format Input and Output, InputTablesSame ('true') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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