percentiletdigest

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

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 

select PERCENTILETDIGEST(homeRuns, 80) AS value
from baseballStats 

select PERCENTILETDIGEST(homeRuns, 99.9) AS value
from baseballStats