GMMProfile Example 3: DP-GMM, Full 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 dpgmm_output_ex3 PARTITION BY 1) AS dt;

Output

cluster_id dimension delta_mean divergence
0 sepal_length 4.73895876769374e-05 0.000842800676834253
0 sepal_width 2.49455044005415e-05 0.000242162712723835
0 petal_length 2.98481673845981e-05 0.000405320200113018
0 petal_width 9.46158435407194e-06 5.66377087165802e-05
1 sepal_length -5.73414583160092 10.5902462122522
1 sepal_width -3.01840904484509 4.51767585748242
1 petal_length -3.61163185795375 2.74025758207281
1 petal_width 3 1.09110505488604
2 sepal_length -5.73414583160092 10.5902462122522
2 sepal_width -3.01840904484509 4.51767585748242
2 petal_length -3.61163185795375 2.74025758207281
2 petal_width -1.14485284940863 1.09110505488604