Apache Pinot Docs
Search…
latest
Configuration Reference
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
Copy link