| description |
|---|
This section contains reference documentation for the PERCENTILETDIGESTMV function. |
Returns the Nth percentile of the group using T-digest algorithm.
PERCENTILETDIGESTMV(colName, N)
These examples are based on the Hybrid Quick Start.
select PERCENTILETDIGESTMV(DivLongestGTimes, 50) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1| value |
|---|
| 10 |
select PERCENTILETDIGESTMV(DivLongestGTimes, 90) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1| value |
|---|
| 44 |
select PERCENTILETDIGESTMV(DivLongestGTimes, 99.9) AS value
from airlineStats
where arraylength(DivLongestGTimes) > 1| value |
|---|
| 108 |