1 of 1

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)

These examples are based on the Batch Quick Start.

select percentileest(homeRuns, 50) AS value
from baseballStats

value

select percentileest(homeRuns, 80) AS value
from baseballStats

value

select percentileest(homeRuns, 99.9) AS value
from baseballStats

value

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

select percentileest(homeRuns, 80) AS value
from baseballStats

value

select percentileest(homeRuns, 99.9) AS value
from baseballStats

value