Output - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

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