Approximate Percentile Example - Teradata Vantage

This example calculates the approximate percentiles 0, 25, 50, 75, and 100 within a 2% error rate for four brands of crackers.

Input

The input table is cracker, as in the Approximate Cardinality Example.

SQL Call

SELECT * FROM ApproxPercentileReduce (
  ON ApproxPercentileMap (
    ON cracker AS InputTable
    USING
    TargetColumns ('pricesunshine','pricekeebler','pricenabisco','priceprivate')
    GroupColumns ('choice')
    ErrorRate (2)
  ) AS InputTable PARTITION BY choice
  USING
  GroupColumns ('choice')
  Percentile (0,25,50,75,100)
  TargetColumns ('pricesunshine','pricekeebler', 'pricenabisco','priceprivate')
) AS dt ORDER BY choice, percentile;

Output