7.00.02 - Histogram (Hist) Arguments - 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)
InputTable
Specifies the name of the table that contains the input data.
OutputTable
Specifies the name for the table that the function generates for the output.
AutoBin
[Optional] If you specify this argument, you must not specify CustomBinTable, CustomBinColumn, StartValue, BinSize, or EndValue.

Specifies either the algorithm to be used for selecting bin boundaries or the approximate number of bins to find. The number_of_bins must be a positive integer.

CustomBinTable
[Optional] If you specify this argument, you must also specify CustomBinColumn, and you must not specify AutoBin, StartValue, BinSize, or EndValue.

Specifies the name of the table that contains the boundary points between bins.

CustomBinColumn
[Optional] If you specify this argument, you must also specify CustomBinTable, and you must not specify AutoBin, StartValue, BinSize, or EndValue.

Specifies the name of the bin_table column that contains the boundary values. This column must have a numeric SQL data type.

StartValue
[Optional] If you specify this argument, you must also specify BinSize and EndValue, and you must not specify AutoBin, CustomBinTable, or CustomBinColumn.

Specifies the smallest value to use in binning.

EndValue
[Optional] If you specify this argument, you must also specify StartValue and BinSize, and you must not specify AutoBin, CustomBinTable, or CustomBinColumn.

Specifies the largest value to use in binning.

BinSize
[Optional] If you specify this argument, you must also specify StartValue and EndValue, and you must not specify AutoBin, CustomBinTable, or CustomBinColumn.

Specify this argument only for equally sized bins. The bin_size is the width of each bin, a positive DOUBLE PRECISION value.

GroupByColumns
[Optional] Specifies the name of the input_table columns that contain the group values for binning. These columns cannot contain DOUBLE PRECISION or FLOAT values.
Inclusion
[Optional] Specifies whether to include points on bin boundaries in the bin on the left or the bin on the right. Default: 'left'.
ValueColumn
Specifies the name of the input_table column for which to compute statistics. This column must have a numeric SQL data type.