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

Signature

PERCENTILETDIGESTMV(colName, N)

Usage Examples

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