Aggregates Aggregate

reservoir_quantile()

Gives the approximate quantile using reservoir sampling, the sample size is optional and uses 8192 as a default size.

Arguments & returns

32 overloads

Aggregate

Overload link	`x`	`quantile`	Returns
#01	`BIGINT`	`DOUBLE`	`BIGINT`
#02	`BIGINT`	`DOUBLE[]`	`BIGINT[]`
#03	`DECIMAL`	`DOUBLE`	`DECIMAL`
#04	`DECIMAL`	`DOUBLE[]`	`DECIMAL[]`
#05	`DOUBLE`	`DOUBLE`	`DOUBLE`
#06	`DOUBLE`	`DOUBLE[]`	`DOUBLE[]`
#07	`FLOAT`	`DOUBLE`	`FLOAT`
#08	`FLOAT`	`DOUBLE[]`	`FLOAT[]`
#09	`HUGEINT`	`DOUBLE`	`HUGEINT`
#10	`HUGEINT`	`DOUBLE[]`	`HUGEINT[]`
#11	`INTEGER`	`DOUBLE`	`INTEGER`
#12	`INTEGER`	`DOUBLE[]`	`INTEGER[]`
#13	`SMALLINT`	`DOUBLE`	`SMALLINT`
#14	`SMALLINT`	`DOUBLE[]`	`SMALLINT[]`
#15	`TINYINT`	`DOUBLE`	`TINYINT`
#16	`TINYINT`	`DOUBLE[]`	`TINYINT[]`

Aggregate

Overload link	`x`	`quantile`	`sample_size`	Returns
#17	`BIGINT`	`DOUBLE`	`INTEGER`	`BIGINT`
#18	`BIGINT`	`DOUBLE[]`	`INTEGER`	`BIGINT[]`
#19	`DECIMAL`	`DOUBLE`	`INTEGER`	`DECIMAL`
#20	`DECIMAL`	`DOUBLE[]`	`INTEGER`	`DECIMAL[]`
#21	`DOUBLE`	`DOUBLE`	`INTEGER`	`DOUBLE`
#22	`DOUBLE`	`DOUBLE[]`	`INTEGER`	`DOUBLE[]`
#23	`FLOAT`	`DOUBLE`	`INTEGER`	`FLOAT`
#24	`FLOAT`	`DOUBLE[]`	`INTEGER`	`FLOAT[]`
#25	`HUGEINT`	`DOUBLE`	`INTEGER`	`HUGEINT`
#26	`HUGEINT`	`DOUBLE[]`	`INTEGER`	`HUGEINT[]`
#27	`INTEGER`	`DOUBLE`	`INTEGER`	`INTEGER`
#28	`INTEGER`	`DOUBLE[]`	`INTEGER`	`INTEGER[]`
#29	`SMALLINT`	`DOUBLE`	`INTEGER`	`SMALLINT`
#30	`SMALLINT`	`DOUBLE[]`	`INTEGER`	`SMALLINT[]`
#31	`TINYINT`	`DOUBLE`	`INTEGER`	`TINYINT`
#32	`TINYINT`	`DOUBLE[]`	`INTEGER`	`TINYINT[]`

SELECT reservoir_quantile(A, 0.5, 1024)
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("A");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

SELECT
  reservoir_quantile(A, 0.5, 1024);