TD_​Histogram

fastpath function to perform histogram calculation on a data set, which accepts either auto-generated bins, Equal-Width bins and Variable-Width bins, output <ColumnName, label, MinValue, MaxValue, CountOfValues, bin_percent>.

Options

GroupbyColumns
Specify the names of the InputTable columns that contain the group values for binning.
Inclusion
Specify whether to include points on bin boundaries in the bin on the left or the bin on the right. If only 1 value is specified, then it will be applied to all the target columns, else the number of Inclusion values must be equal to the number of target columns.
MethodType
Specify the MethodType which will be used for histogram computation. Supported MethodType are {STURGES, SCOTT, EQUAL-WIDTH, VARIABLE-WIDTH}.
NBins (integers seperated by new line)
Specify the integer value which will specify the number of ranges or bins. If only 1 value is specified, then it will be applied to all the target columns, else the number of NBins values must be equal to the number of target columns.
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
TargetColumn
Specifies the input table columns for which histogram computation is to be done.
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
The relation that contains input data.
Icon
The relation that contains bin data for EQUAL-WIDTH and VARIABLE-WIDTH.

Output Ports

Icon
output of TD_Histogram

Nodes

Extensions

Links