Apache Pinot Docs
Search…
latest
Configuration Reference
percentiletdigest
This section contains reference documentation for the PERCENTILETDigest function.
Returns the Nth percentile of the group using T-digest algorithm.

Signature

PERCENTILETDigest(colName, percentile)

Usage Examples

These examples are based on the Batch Quick Start.
1
select PERCENTILETDigest(homeRuns, 50) AS value
2
from baseballStats
Copied!
value
0
1
select PERCENTILETDigest(homeRuns, 80) AS value
2
from baseballStats
Copied!
value
3.6571905392487856
1
select PERCENTILETDigest(homeRuns, 99.9) AS value
2
from baseballStats
Copied!
value
46.26787306220119
Copy link