The Approximate Percentile function, composed of ApproxPercentileReduce and ApproxPercentileMap, computes approximate percentiles for one or more columns of data. The nth percentile is the smallest value in a data set that is greater than n% of the values. The larger the data set, the more accurate the approximate percentile.