description
This section contains reference documentation for the PERCENTILEESTMV function.

percentileestmv

Returns the Nth percentile of the group using Quantile Digest algorithm.

Signature

PERCENTILEESTMV(colName, N)

These examples are based on the Hybrid Quick Start.

select PERCENTILEESTMV(DivLongestGTimes, 50) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

value
10

select PERCENTILEESTMV(DivLongestGTimes, 90) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

value
44

select PERCENTILEESTMV(DivLongestGTimes, 99.9) AS value
from airlineStats 
where arraylength(DivLongestGTimes) > 1

value
108