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

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Input

SQL Call

SELECT * FROM GMMProfile (
  ON gmm_output_ex2 PARTITION BY 1) AS dt;

Output

cluster_id dimension delta_mean divergence
0 sepal_length -0.677320892668685 1.56665345847061
0 sepal_width -0.219505733446018 1.2810258018667
0 petal_length -1.02416631831392 19.6670607416453
0 petal_width -0.37708914809821 10.9292686993842
1 sepal_length 0.522787967680891 3.37066588614461
1 sepal_width -0.139247803273395 0.281697224983674
1 petal_length 1.28010561757069 90.6304611514261
1 petal_width 0.526132131319777 53.0187160158947
2 sepal_length -0.89094580649238 1.83064596361469
2 sepal_width 0.339456494564966 0.830916130524456
2 petal_length -2.34360488836621 8.47111633435205
2 petal_width -0.974437952895717 5.58611445150111