Because the SQL-MapReduce call set PackOutput to 1, a single mean column displays a vector containing the mean value for each dimension. See the schema for argument definitions.
An output message table (immediately following) and an output table are shown below.
property | value |
---|---|
Output Table | gmm_output_ex1 |
Algorithm Used | Basic GMM |
... | ... |
Stopping Criterion | Iteration limit reached |
Delta Log Likelihood | 0.013310 |
Number of Iterations | 10 |
Number of Clusters | 3 |
Covariance Type | spherical |
... | ... |
Number of Data Points | 120 |
Global Mean | [5.866, 3.055, 3.770, 1.205] |
Global Covariance | [[0.7197, -0.04204, 1.326, 0.5265], [-0.04204, 0.1916, -0.3241, -0.1213], [1.326, -0.3241, 3.167, 1.298], [0.5265, -0.1213, 1.298, 0.5708]] |
... | ... |
Log Likelihood | -364.450 |
Akaike Information Criterion | 762.899 on 17 parameters |
Bayesian Information Criterion | 810.287 on 17 parameters |
The following query returns the output shown in the following table:
SELECT * FROM gmm_output_ex1 ORDER BY cluster_id;
cluster_id | points_assigned | covariance_type | weight |
---|---|---|---|
0 | 1 | spherical | 0.00833333333333333 |
1 | 39 | spherical | 0.324999998499867 |
2 | 80 | spherical | 0.6666666681668 |
mean | covariance | determinant | prec |
---|---|---|---|
[4.5, 2.299999952316284, 1.2999999523162842, 0.30000001192092896] | 1.0E-12 | 1e-48 | 1.0E12 |
[5.010256409188803, 3.446153855805786, 1.44615384307372, 0.2512820560787926] | 0.07235370835810885 | 2.74058439183871e-05 | 13.820991662937034 |
[6.299999998810371, 2.873750007907585, 4.9337499775605185, 1.6812499819268993] | 0.3514238290308256 | 0.0152519307815099 | 2.84556685514995 |