7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)

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 with the associated p-value.

distnmatch (Best Match Mode) Example 2 Output Table (Columns 1-4)
park_name season group_size best_match_KS_top1
KidsWorld Spring 400 UNIFORMDISCRETE:1,8
KidsWorld Summer 400 POISSON:4.457499980926514
Funland Spring 400 UNIFORMDISCRETE:1,12
Funland Summer 400 POISSON:7.065000057220459
Wonderland Spring 400 BINOMIAL:16,0.5091542759742608
Wonderland Summer 400 POISSON:7.005000114440918
distnmatch (Best Match Mode) Example 2 Output Table (Columns 5-7)
p-value_KS_top1 best_match_AD_top1 p-value_AD_top1
0.963945 BINOMIAL:100,0.5 1.5e-06
0.996074 BINOMIAL:100,0.5 1.5e-06
0.999293 NEGATIVEBINOMIAL:7,0.46705571565376613 1.5e-06
0.000672657 BINOMIAL:13,0.507505492077339 1.5e-06
0.0624169 BINOMIAL:16,0.5091542759742608 1.5e-06
0.993134 POISSON:7.005000114440918 6.47109e-06
distnmatch (Best Match Mode) Example 2 Output Table (Columns 8-9)
best_match_CHISQ_top1 p-value_CHISQ_top1
BINOMIAL:100,0.5 0
BINOMIAL:100,0.5 0
UNIFORMDISCRETE:1,12 8.9484e-13
BINOMIAL:13,0.507505492077339 0
BINOMIAL:16,0.5091542759742608 0
BINOMIAL:110,0.06332936686652757 0