KMeans Example 1: NumClusters, UnpackColumns ('false') by Default - Teradata Vantage

Input

The InputTable has five attributes of personal computers (price, speed, hard disk size, RAM, and screen size). The table has over 6000 rows. These examples use different arguments to find eight clusters based on the five attributes.

SQL Call

This call tries to group the 5-dimensional data points into 8 clusters.

SELECT * FROM KMeans (
  ON computers_train1 AS InputTable
  OUT TABLE OutputTable (kmeanssample_centroid)
  USING
  NumClusters (8)
  StopThreshold (0.05)
  MaxIterNum (10)
) AS dt;

Output

This query returns the following table:

SELECT * FROM kmeanssample_centroid;