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)

The output is shown in expanded output mode. The function has attempted to identify the best matching distribution for each partition of the data, based on each test specified in the SQL-MapReduce call. For each partition, the output shows the distribution and parameters identified by each test, and the associated p-value.

distnmatch (Best Match Mode) Example 1 Output Table
Column Name Value
-[ RECORD 1 ]------------- ---------------------------------------------------------------------------
factory F1
product A
group_size 4000
best_match_KS_top1 GAMMA:4494.418836778631,2.2249176761705147
p-value_KS_top1 0.921247
best_match_AD_top1 GAMMA:4494.418836778631,2.2249176761705147
p-value_AD_top1 0.992539
best_match_CHISQ_top1 LOGNORMAL:9.210200309753418,0.014922354370355606
p-value_CHISQ_top1 0.873597
-[ RECORD 2 ]------------- ---------------------------------------------------------------------------
factory F1
product C
group_size 4000
best_match_KS_top1 BETA:10,1
p-value_KS_top1 8.73764e-07
best_match_AD_top1 BETA:10,1
p-value_AD_top1 1.5e-07
best_match_CHISQ_top1 BETA:10,1
p-value_CHISQ_top1 0
-[ RECORD 3 ]------------- ---------------------------------------------------------------------------
factory F2
product B
group_size 4000
best_match_KS_top1 LOGNORMAL:9.210394859313965,0.009947648271918297
p-value_KS_top1 0.717749
best_match_AD_top1 GAMMA:10199.47546584695,0.9805440671668431
p-value_AD_top1 0.908634
best_match_CHISQ_top1 LOGNORMAL:9.210394859313965,0.009947648271918297
p-value_CHISQ_top1 0.356182
-[ RECORD 4 ]------------- ---------------------------------------------------------------------------
factory F2
product D
group_size 4000
best_match_KS_top1 UNIFORMCONTINUOUS:9500.3388671875,10499.8486328125
p-value_KS_top1 0.721553
best_match_AD_top1 BETA:10,1
p-value_AD_top1 1.5e-07
best_match_CHISQ_top1 UNIFORMCONTINUOUS:9500.3388671875,10499.8486328125
p-value_CHISQ_top1 0.911413