1.0 - 8.00 - Histogram Example 2: AutoBin ('Scott') - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

SQL Call

DROP TABLE IF EXISTS cars_scott_out;

SELECT * FROM Histogram (
  ON cars_hist AS InputTable
  OUT TABLE OutputTable (cars_scott_out)
  USING       
  AutoBin ('Scott')
  TargetColumn ('hp')
) AS dt;

Output

output_table output_columns
specified in OutputTable argument bin bin_start bin_end bin_count bin_percent

This query returns the following table:

SELECT * FROM cars_scott_out ORDER BY 1;
cars_scott_out
bin bin_start bin_end bin_count bin_percent
0 0 100 9 28.13
1 100 200 16 50.00
2 200 300 6 18.75
3 300 400 1 3.13