7.00.02 - Approximate Percentile Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
TargetColumns
Specifies the names of the input columns for which to compute approximate percentiles.

If you specify only one target_column in the ApproxPercentileMap function, you can omit this argument in the ApproxPercentileReduce function.

If you specify more than one target_column in the ApproxPercentileMap function, you must specify this argument in the ApproxPercentileReduce function. In ApproxPercentileReduce, this argument must specify at least one target_column that it specifies in ApproxPercentileMap. Only the target columns specified in ApproxPercentileReduce appear in the output table.

ErrorRate
[Optional] Specifies the error (desired accuracy) of the approximation; that the quantile is to be correct within error%. The error must be in the range [.01, 50]. Default: 1. Lower error is more accurate but takes longer to compute.
Percentile
[Optional] Specifies the approximate percentiles to compute. Each percentile is an INTEGER. Default behavior: The function computes the percentiles 0, 25, 50, 75, and 100.
GroupColumns
[Optional] Specifies the names of the input columns by which to group the data.

If you specify this argument, the function computes the approximate percentile for each group in each column. For example, if the target columns are State, Town, and Population, the function computes the approximate percentile for the population of each state.

If you omit this argument, the function computes the approximate percentile for the entire column. For example, if the target columns are State, Town, and Population, the function computes the approximate percentile for the population across all towns.

To specify this argument, you must do so in both the ApproxPercentileMap and the ApproxPercentileReduce functions, and specify each group_column in the PARTITION BY clause.

If you omit this argument, specify PARTITION BY 1.