Apache Pinot Docs
Search…
latest
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.
1
select percentileest(homeRuns, 50) AS value
2
from baseballStats
Copied!
value
0
1
select percentileest(homeRuns, 80) AS value
2
from baseballStats
Copied!
value
4
1
select percentileest(homeRuns, 99.9) AS value
2
from baseballStats
Copied!
value
46
Last modified 1mo ago
Copy link