1 of 1

percentiletdigestmv

This section contains reference documentation for the PERCENTILETDIGESTMV function.

Returns the Nth percentile of the group using T-digest algorithm. An optional compression_factor can be specified to control the accuracy with a tradeoff in memory usage (i.e. higher compression_factor gives better accuracy but takes more memory). The default compression_factor is 100.

Signature

PERCENTILETDIGESTMV(colName, percentile)
PERCENTILETDIGESTMV(colName, percentile, compression_factor)

Usage Examples

These examples are based on the .

value

percentiletdigestmv

This section contains reference documentation for the PERCENTILETDIGESTMV function.

Signature

PERCENTILETDIGESTMV(colName, percentile)
PERCENTILETDIGESTMV(colName, percentile, compression_factor)

Usage Examples

These examples are based on the .

value

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

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

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

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

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

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

percentiletdigestmv

hashtagSignature

hashtagUsage Examples

percentiletdigestmv

hashtagSignature

hashtagUsage Examples

Signature

Usage Examples

Signature

Usage Examples