TD_Histogram Input - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

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.