7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

This query returns the output shown in the table cfilter_output:

SELECT * FROM cfilter_output ORDER BY region, score;

Because all cntb values are equal, no z-scores appear.

CFilter Example 1 Output Table cfilter_output (Columns 1-6)
region col1_item1 col1_item2 cntb cnt1 cnt2
Atlantic Paper Office Furnishings 1 4 5
Atlantic Office Furnishings Paper 1 5 4
Atlantic Binders and Binder Accessories Office Furnishings 1 3 5
Atlantic Office Furnishings Binders and Binder Accessories 1 5 3
Atlantic Computer Peripherals Office Furnishings 1 2 5
Atlantic Office Furnishings Computer Peripherals 1 5 2
Atlantic Labels Pens & Art Supplies 1 3 2
Atlantic Pens & Art Supplies Labels 1 2 3
... ... ... ... ... ...
CFilter Example 1 Output Table cfilter_output (Columns 7-11)
score support confidence lift z_score
0.05 0.0555555555555556 0.25 0.9  
0.05 0.0555555555555556 0.2 0.9  
0.0666666666666667 0.0555555555555556 0.333333333333333 1.2  
0.0666666666666667 0.0555555555555556 0.2 1.2  
0.1 0.0555555555555556 0.5 1.8  
0.1 0.0555555555555556 0.2 1.8  
0.166666666666667 0.0555555555555556 0.333333333333333 3  
0.166666666666667 0.0555555555555556 0.5 3  
... ... ... ... ...