Skip to content

approx_percentile()

Estimate the value at a given percentile from a `tdigest`

Since 1.0.0

Estimate the approximate value at a percentile from a tdigest aggregate.

Estimate the value at the first percentile, given a sample containing the numbers from 0 to 100.

SELECT
approx_percentile(0.01, tdigest(100, data))
FROM generate_series(0, 100) data;
approx_percentile
-------------------
0.51

The syntax is:

approx_percentile(
quantile DOUBLE PRECISION,
digest TDigest
) RETURNS DOUBLE PRECISION
NameTypeDefaultRequiredDescription
quantileDOUBLE PRECISION-✔The percentile to compute. Values outside the range [0.0, 1.0] are treated as 0.0 or 1.0
digestTDigest-✔The tdigest aggregate
ColumnTypeDescription
approx_percentileDOUBLE PRECISIONThe estimated value at the requested percentile.