Input
- Input table: gmm_output_ex2, output by GMM Example: Basic GMM, Diagonal Covariance, Unpacked Output
SQL Call
SELECT * FROM GMMProfile ( ON gmm_output_ex2 PARTITION BY 1 ) AS dt;
Output
cluster_id dimension delta_mean divergence ---------- ------------ -------------------- --------------------- 0 sepal_length -1.3658333333333366 15.342132372030921 0 sepal_width -0.7550000000000016 14.834050738899432 0 petal_length -2.4700000000000024 19.130912814339993 0 petal_width -0.9050000000000005 15.675363062873892 1 sepal_length 0.4341665830400491 1.5367707394138987E10 1 sepal_width -0.18124996295211418 1.840104401880575E9 1 petal_length 1.1637497791844298 5.783072541030532E10 1 petal_width 0.4762499242214078 8.656770301204807E9 2 sepal_length -0.8555769287192753 1.6207265395178976E9 2 sepal_width 0.39115384879464943 5.990384704575897E9 2 petal_length -2.3238461800148213 1.9123928253990194E8 2 petal_width -0.9537179897227525 6.089740988974346E7
Download a zip file of all examples and a SQL script file that creates their input tables.