| description |
|---|
This section contains reference documentation for the percentileest function. |
Returns the Nth percentile of the group using Quantile Digest algorithm.
percentileest(colName, percentile)
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 |