Input
- Input table: gmm_output_ex1, output by GMM Example: Basic GMM, Spherical Covariance, Packed Output
SQL Call
SELECT * FROM GMMProfile ( ON gmm_output_ex1 PARTITION BY 1 ) AS dt;
Output
cluster_id dimension delta_mean divergence ---------- --------- -------------------- ------------------ 0 0 -0.8683333333337775 2.352317121517356 0 1 0.3624999999821591 1.06692144493526 0 2 -2.3274999999740156 16.91053063503435 0 3 -0.9524999999859484 2.9487939520833013 1 0 -0.6311092718136166 1.872749456485776 1 1 -0.7129568015279435 3.0375092869508227 1 2 -0.24574367285799514 11.872102517773868 1 3 -0.13376997356364878 2.145435485671642 2 0 0.5389789434803692 5.1484229268155435 2 1 -0.12893547898895083 0.969666816498592 2 2 1.3024297877141255 28.959753927335363 2 3 0.5362697376272012 5.129335671098968
Download a zip file of all examples and a SQL script file that creates their input tables.