Apache Pinot Docs
Search…
latest
Configuration Reference
percentile
This section contains reference documentation for the percentile function.
Returns the max - min value in a group

Signature

percentile(colName, percentile)

Usage Examples

These examples are based on the Batch Quick Start.
1
select percentile(homeRuns, 50) AS value
2
from baseballStats
Copied!
value
0
1
select percentile(homeRuns, 80) AS value
2
from baseballStats
Copied!
value
4
1
select percentile(homeRuns, 99.9) AS value
2
from baseballStats
Copied!
value
46
Last modified 6mo ago
Copy link