Optional Syntax Elements for TD_Histogram - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
ON clause for Dimension
Accept the MinMax table clause.
NBins
[Required with methods Equal-Width and Variable-Width] Specify the integer value which will specify the number of ranges or bins.
If only one value is specified, it is applied to all the target columns. Otherwise, the number of NBins values must be equal to the number of target columns.
The maximum NBins value is 10000.
Inclusion
Specify whether to include points on bin boundaries, in the bin to the left of the boundary or the bin to the right of the boundary.
If only one value is specified, it is applied to all the target columns. Otherwise, the number of Inclusion values must be equal to the number of target columns.
Default: left
GroupByColumns
Specify the names of the InputTable columns that contain the group values for binning.
This argument must not have columns that are already specified in TargetColumn.
This argument does not support range.
The maximum number of unique columns in the GroupByColumns argument is 2042.