Aggregates Aggregate

reservoir_quantile()

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

Reference: DuckDB 2.0.0

Arguments & returns

16 overloads

reservoir_quantile(x, quantile, sample_size)

Aggregate
Overload link xquantilesample_size Returns
#01 BIGINTDOUBLEINTEGER BIGINT
#02 BIGINTDOUBLE[]INTEGER BIGINT[]
#03 DECIMALDOUBLEINTEGER DECIMAL
#04 DECIMALDOUBLE[]INTEGER DECIMAL[]
#05 DOUBLEDOUBLEINTEGER DOUBLE
#06 DOUBLEDOUBLE[]INTEGER DOUBLE[]
#07 FLOATDOUBLEINTEGER FLOAT
#08 FLOATDOUBLE[]INTEGER FLOAT[]
#09 HUGEINTDOUBLEINTEGER HUGEINT
#10 HUGEINTDOUBLE[]INTEGER HUGEINT[]
#11 INTEGERDOUBLEINTEGER INTEGER
#12 INTEGERDOUBLE[]INTEGER INTEGER[]
#13 SMALLINTDOUBLEINTEGER SMALLINT
#14 SMALLINTDOUBLE[]INTEGER SMALLINT[]
#15 TINYINTDOUBLEINTEGER TINYINT
#16 TINYINTDOUBLE[]INTEGER TINYINT[]

Example

reservoir_quantile example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example with sample data ยท Run to view results.