Powered by GitBook

1 of 1

Loading...

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 .

value

value

value

select percentileest(homeRuns, 50) AS value
from baseballStats

0

4

46

Batch Quick Start

select percentileest(homeRuns, 80) AS value
from baseballStats

select percentileest(homeRuns, 99.9) AS value
from baseballStats