percentileest

This section contains reference documentation for the percentileest function.

Returns the Nth percentile of the group using Quantile Digest algorithm.

Signature

percentileest(colName, percentile)

Usage Examples

These examples are based on the Batch Quick Start.

select percentileest(homeRuns, 50) AS value
from baseballStats 

value
0

select percentileest(homeRuns, 80) AS value
from baseballStats 

value
4

select percentileest(homeRuns, 99.9) AS value
from baseballStats 

value
46