Powered by GitBook

1 of 1

Loading...

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 .

value

value

value

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

10

44

108

Hybrid Quick Start

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

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