GMM Example 3: DP-GMM, Full Covariance, Unpacked Output - Teradata Vantage

Dirichlet Process GMM (DP-GMM) estimates the number of clusters in the data using an algorithm based on variational Bayesian methods.

SQL Call

DROP TABLE dpgmm_output_ex3;

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

Output

This query returns the following table:

SELECT * FROM dpgmm_output_ex3 ORDER BY cluster_id;