TD_Histogram Input - 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

InputTable Schema

Column Data Type Description
target_column BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT, REAL, DOUBLE PRECISION Indicates the columns to use with the function.
group_column BYTEINT, SMALLINT, INTEGER, BIGINT, CHAR, VARCHAR

Character types: Character set can be LATIN or UNICODE.

Determines how input data is grouped. The function produces a separate histogram for each group.
The column appears once for each specified group_column.

MinMaxTable Schema: MethodType - Equal-Width

Column Data Type Description
ColumnName CHAR or VARCHAR

Character types: Character set can be LATIN or UNICODE.

Target column names. It is required only when more than one target column is specified.
MinValue BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT, REAL, DOUBLE PRECISION Overall minimum value of the bins.
MaxValue BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT, REAL, DOUBLE PRECISION Overall maximum value of the bins.

MinMaxTable Schema: MethodType - Variable-Width

Column Data Type Description
ColumnName CHAR or VARCHAR

Character types: Character set can be LATIN or UNICODE.

Target column names. It is required only when more than one target column is specified.
MinValue BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT, REAL, DOUBLE PRECISION Minimum value of the bin.
MaxValue BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT, REAL, DOUBLE PRECISION Maximum value of the bin.
Label CHAR, VARCHAR, BYTEINT, SMALLINT, INTEGER, or BIGINT

Character types: Character set can be LATIN or UNICODE.

Corresponding labels for bins or data value ranges.

Maximum label length: 128 UNICODE characters.