GMMProfile Example: Basic GMM, Spherical Covariance, Packed Output - Teradata Vantage

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 from the attachment in the left sidebar.