KMeans Example 3: InitialSeeds, ClusteredOutput - Teradata Vantage

Input

• InputTable: computers_train1, as in KMeans Example 1: NumClusters, UnpackColumns ('false') by Default

SQL Call

SELECT * FROM KMeans (
  ON computers_train1 AS InputTable
  OUT TABLE OutputTable (kmeanssample_output)
  OUT TABLE ClusteredOutput (kmeanssample_clusteredoutput)
  USING
  InitialSeeds ('2249_51_408_8_14', '2165_51_398_7_14.6',
    '2182_51_404_7_14.6', '2204_55_372_7.19_14.6',
    '2419_44_222_6.6_14.3', '2394_44.3_277_7.3_14.5','
    2326_43.6_301_7.11_14.3', '2288_44_325_7_14.4')
) AS dt;

Output

This query returns the following table:

SELECT * FROM kmeanssample_output ORDER BY clusterid;

This query returns the following table:

SELECT * FROM kmeanssample_clusteredoutput ORDER BY id;