Canopy Example - Teradata Vantage

Machine Learning Engine Analytic Function Reference
Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

Input

The input table has more than 6000 rows of computer specifications.

InputTable: computers_train1
id price speed hd ram screen
1 1499 25 80 4 14
2 1795 33 85 2 14
3 1595 25 170 4 15
4 1849 25 170 8 14
5 3295 33 340 16 14
6 3695 66 340 16 14
7 1720 25 170 4 14
8 1995 50 85 2 14
9 2225 50 210 2 14
12 2605 66 210 8 14
13 2045 50 130 4 14
14 2295 25 245 8 14
16 2225 50 130 4 14
17 1595 33 85 2 14
18 2325 33 210 4 15
19 2095 33 250 4 15
20 4395 66 452 8 14
... ... ... ... ... ...

SQL Call

SELECT * FROM Canopy (
  ON computers_train1 AS InputTable
  USING
  LooseDistance (1000)
  TightDistance (500)
) AS dt ORDER BY canopyid;

Output

canopyid price speed hd ram screen
1 1946.92 48.8442 341.391 6.07969 14.4756
2 2511.81 54.7 445.15 9.80651 14.7219
3 3764.45 64.2245 541.782 12.1361 15.2585
4 4489.81 64.5714 734.286 14.4762 15.7619
5 3052.15 61.7052 637.072 15.0761 14.9484