7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

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.

GMMFit Example 1 Output Message Table
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;
GMMFit Example 1 Output Table gmm_output_ex1 (Columns 1-4)
cluster_id points_assigned covariance_type weight
0 1 spherical 0.00833333333333333
1 39 spherical 0.324999998499867
2 80 spherical 0.6666666681668
GMMFit Example 1 Output Table gmm_output_ex1 (Columns 5-8)
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