TD_UnivariateStatistics

This function takes a input table partitioned by ANY and a set of numeric target columns and generates a set of statistics for each target columns.

Options

Centiles (integers seperated by new line): This argument is applicable only when the Percentiles (PRC) or ALL stats is provided in the Stats argument. Specify the particular percentile value to be calculated. This argument can accept multiple unique integer values between 1 to 100.
PartitionColumns: Specify the names of the input partition columns.
Stats (strings seperated by new line): Specify any actual/alternate statistics names to be calculated for the 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
TargetColumns: Specify the NUMERIC input target columns or column range.
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.
TrimPercentile: This argument is applicable only when the Trimmed Mean (TM) or ALL stats is provided in the Stats argument. This argument can accept only one integer values between 1 to 50. Calculates mean of all the values laying in between the trimmed lower percentile (trim_percentage) and trimmed upper percentile (100 – trimmed_percentage).