GMM Example 1: Basic GMM, Spherical Covariance, Packed Output - Teradata Vantage

SQL Call

SELECT * FROM GMM (
  ON (SELECT 1) AS init_params PARTITION BY 1
  ON gmm_iris_train AS InputTable
  OUT TABLE OutputTable (gmm_output_ex1)
  USING
  ClusterNum (3)
  CovarianceType ('spherical')
  MaxIterNum (10)
  PackOutput (1)
) AS dt;

Output

Because the SQL call specifies PackOutput (1), a single mean column displays a vector containing the mean value for each dimension.

This query returns the following table:

SELECT * FROM gmm_output_ex1 ORDER BY cluster_id;