Apache Pinot Docs
Search…
latest
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
Last modified 18d ago
Copy link