Apache Pinot Docs
Search…
latest
Configuration Reference
percentileestmv
This section contains reference documentation for the PERCENTILEESTMV function.
Returns the Nth percentile of the group using Quantile Digest algorithm.

Signature

PERCENTILEESTMV(colName, N)

Usage Examples

These examples are based on the Hybrid Quick Start.
1
select PERCENTILEESTMV(DivLongestGTimes, 50) AS value
2
from airlineStats
3
where arraylength(DivLongestGTimes) > 1
Copied!
value
10
1
select PERCENTILEESTMV(DivLongestGTimes, 90) AS value
2
from airlineStats
3
where arraylength(DivLongestGTimes) > 1
Copied!
value
44
1
select PERCENTILEESTMV(DivLongestGTimes, 99.9) AS value
2
from airlineStats
3
where arraylength(DivLongestGTimes) > 1
Copied!
value
108
Copy link