Aggregates Aggregate

approx_quantile()

Computes the approximate quantile using T-Digest.

Arguments & returns

24 overloads

Aggregate

Overload link	`x`	`pos`	Returns
#01	`BIGINT`	`FLOAT`	`BIGINT`
#02	`BIGINT`	`FLOAT[]`	`BIGINT[]`
#03	`DATE`	`FLOAT`	`DATE`
#04	`DATE`	`FLOAT[]`	`DATE[]`
#05	`DECIMAL`	`FLOAT`	`DECIMAL`
#06	`DECIMAL`	`FLOAT[]`	`DECIMAL[]`
#07	`DOUBLE`	`FLOAT`	`DOUBLE`
#08	`DOUBLE`	`FLOAT[]`	`DOUBLE[]`
#09	`FLOAT`	`FLOAT[]`	`FLOAT[]`
#10	`HUGEINT`	`FLOAT`	`HUGEINT`
#11	`HUGEINT`	`FLOAT[]`	`HUGEINT[]`
#12	`INTEGER`	`FLOAT`	`INTEGER`
#13	`INTEGER`	`FLOAT[]`	`INTEGER[]`
#14	`SMALLINT`	`FLOAT`	`SMALLINT`
#15	`SMALLINT`	`FLOAT[]`	`SMALLINT[]`
#16	`TIME WITH TIME ZONE`	`FLOAT`	`TIME WITH TIME ZONE`
#17	`TIME WITH TIME ZONE`	`FLOAT[]`	`TIME WITH TIME ZONE[]`
#18	`TIME`	`FLOAT`	`TIME`
#19	`TIME`	`FLOAT[]`	`TIME[]`
#20	`TIMESTAMP WITH TIME ZONE`	`FLOAT`	`TIMESTAMP WITH TIME ZONE`
#21	`TIMESTAMP WITH TIME ZONE`	`FLOAT[]`	`TIMESTAMP WITH TIME ZONE[]`
#22	`TIMESTAMP`	`FLOAT`	`TIMESTAMP`
#23	`TIMESTAMP`	`FLOAT[]`	`TIMESTAMP[]`
#24	`TINYINT`	`FLOAT[]`	`TINYINT[]`

SELECT approx_quantile(x, 0.5)
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("x");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

PERCENTILE_APPROX(x, 0.5)

In DuckDB

APPROX_QUANTILE(x, 0.5)

APPROX_QUANTILES(x, 1)

In DuckDB

APPROX_QUANTILE(x, [0, 1])

SELECT APPROX_PERCENTILE(a, 0.5) FROM t

In DuckDB

SELECT APPROX_QUANTILE(a, 0.5) FROM t