approx_percentile()

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

approx_percentile(
  percentile DOUBLE PRECISION,
  uddsketch  UddSketch
) 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]`
sketch	UddSketch	-	✔	the `uddsketch` 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, uddsketch(data))
FROM generate_series(0, 100) data;

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

⌘I