percentiletdigest

This section contains reference documentation for the PERCENTILETDIGEST 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. Pinot uses an effective minimum compression factor of 10, so values below 10 behave as 10.

Signature

PERCENTILETDIGEST(colName, percentile)

PERCENTILETDIGEST(colName, percentile, compression_factor)

Usage Examples

These examples are based on the Batch Quick Start.

select PERCENTILETDIGEST(homeRuns, 50, 1000) AS value
from baseballStats 

value
0

select PERCENTILETDIGEST(homeRuns, 80) AS value
from baseballStats 

value
3.6571905392487856

select PERCENTILETDIGEST(homeRuns, 99.9) AS value
from baseballStats 

value
46.26787306220119