percentileest

This section contains reference documentation for the percentileest function.

Returns the Nth percentile of the group using Quantile Digest algorithm.
Signature
percentileest(colName, percentile)
Usage Examples
These examples are based on the Batch Quick Start.
select percentileest(homeRuns, 50) AS value
from baseballStats 
value
0
select percentileest(homeRuns, 80) AS value
from baseballStats 
value
4
select percentileest(homeRuns, 99.9) AS value
from baseballStats 
value
46

value
0

value
4

value
46

percentile

percentileestmv

Last modified 1yr ago