Skip to content

approx_percentile_array()

Estimate the values for an array of given percentiles from a `uddsketch`

Since 1.16.0

Estimate the approximate values of an array of percentiles from a uddsketch aggregate.

Estimate the value at the 90th, 50th, and 20th percentiles, given a sample containing the numbers from 0 to 100.

SELECT
approx_percentile_array(array[0.9,0.5,0.2], uddsketch(100,0.005,data))
FROM generate_series(0, 100) data;
approx_percentile_array
----------------------------------------------------------
{89.12032449087212,49.89808293194989,19.885183706049908}

The syntax is:

approx_percentile_array(
percentiles DOUBLE PRECISION[],
sketch UddSketch
) RETURNS DOUBLE PRECISION[]
NameTypeDefaultRequiredDescription
percentilesDOUBLE PRECISION[]-✔array of percentiles to compute. Must be within the range [0.0, 1.0]
sketchUddSketch-✔the uddsketch aggregate
ColumnTypeDescription
approx_percentile_arrayDOUBLE PRECISION[]The estimated values at the requested percentiles.