1 of 1

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.

Signature

PERCENTILETDIGEST(colName, percentile)
PERCENTILETDIGEST(colName, percentile, compression_factor)

Usage Examples

These examples are based on the .

value

percentiletdigest

This section contains reference documentation for the PERCENTILETDIGEST function.

Signature

PERCENTILETDIGEST(colName, percentile)
PERCENTILETDIGEST(colName, percentile, compression_factor)

Usage Examples

These examples are based on the .

value

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

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

percentiletdigest

hashtagSignature

hashtagUsage Examples

percentiletdigest

hashtagSignature

hashtagUsage Examples

Signature

Usage Examples

Signature

Usage Examples