v.21.7New Feature

Add fast quantileBFloat16 functions in ClickHouse

Official CH changelog text
Add quantileBFloat16 aggregate function as well as the corresponding quantilesBFloat16 and medianBFloat16. It is very simple and fast quantile estimator with relative error not more than 0.390625%. This closes #16641. #23204 (Ivan Novitskiy).
Added the quantileBFloat16 aggregate function along with quantilesBFloat16 and medianBFloat16 for efficient quantile estimation with high accuracy.

Why it matters

These new aggregate functions provide a very simple and fast method for estimating quantiles, offering a relative error of no more than 0.390625%. This improves performance and precision for quantile calculations in analytical queries.

How to use it

Use the aggregate functions quantileBFloat16, quantilesBFloat16, or medianBFloat16 in your SELECT queries just like other quantile functions to compute approximate quantiles with improved speed and guaranteed error bounds.

Related resources

PreviousNext