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)
Histogram Example 3 Output Table
output table output columns
"cars_hist_out" cyl bin bin_start bin_end bin_count bin_percent
The following query returns the output shown in the following table:
SELECT * FROM cars_hist_out ORDER BY 1;
Histogram Example 3 Output Table cars_hist_out
cyl bin bin_start bin_end bin_count bin_percent
4 0 20 70 5 45.45
4 1 70 120 6 54.55
4 2 120 170 0 0.00
4 3 170 220 0 0.00
4 4 220 270 0 0.00
4 5 270 320 0 0.00
4 6 320 370 0 0.00
4 7 370 400 0 0.00
6 0 20 70 0 0.00
6 1 70 120 4 57.14
6 2 120 170 2 28.57
6 3 170 220 1 14.29
6 4 220 270 0 0.00
6 5 270 320 0 0.00
6 6 320 370 0 0.00
6 7 370 400 0 0.00
8 0 20 70 0 0.00
8 1 70 120 0 0.00
8 2 120 170 2 14.29
8 3 170 220 7 50.00
8 4 220 270 4 28.57
8 5 270 320 0 0.00
8 6 320 370 1 7.14
8 7 370 400 0 0.00