approx_percentile()

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

approx_percentile(
  percentile DOUBLE PRECISION,
  tdigest  TDigest
) RETURNS DOUBLE PRECISION

Arguments

Name	Type	Default	Required	Description
percentile	DOUBLE PRECISION	-		The percentile to compute. Must be within the range `[0.0, 1.0]`
tdigest	TDigest	-		The `tdigest` aggregate

Column	Type	Description
approx_percentile	DOUBLE PRECISION	The estimated value at the requested percentile

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

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

approx_percentile
-------------------
            0.999

⌘I