Input
- Input table: dpgmm_output_ex3, output by GMM Example: DP-GMM, Full Covariance, Unpacked Output
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.