GMM Example 2: Basic GMM, Diagonal Covariance, Unpacked Output - Teradata Vantage

SQL Call

DROP TABLE gmm_output_ex2;

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

Output

Because the SQL call specifies PackOutput (0), the mean for each dimension is output in a separate column.

This query returns the following table:

SELECT * FROM gmm_output_ex2 ORDER BY cluster_id;