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. |