1.1 - 8.10 - GMMProfile Example: DP-GMM, Full Covariance, Unpacked Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Published
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

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.738958765390484E-5 8.428006765481954E-4
          0 sepal_width  2.4945504333396743E-5 2.421627114882355E-4
          0 petal_length 2.9848167462291975E-5 4.053202021469186E-4
          0 petal_width   9.461584411438975E-6 5.663770946625795E-5
          1 sepal_length    -5.734145828813979     10.5902460737227
          1 sepal_width     -3.018409036720571    4.517675838918045
          1 petal_length    -3.611631867354723    2.740257586317952
          1 petal_width     -1.144852856350053   1.0911050602645518
          2 sepal_length    -5.734145828813979     10.5902460737227
          2 sepal_width     -3.018409036720571    4.517675838918045
          2 petal_length    -3.611631867354723    2.740257586317952
          2 petal_width     -1.144852856350053   1.0911050602645518

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.