v.21.10Improvements

Add quantileBFloat16Weighted aggregate function to ClickHouse

Add aggregate function quantileBFloat16Weighted similarly to other quantile...Weighted functions. This closes #27745. #27758 (Ivan Novitskiy).
Added the aggregate function quantileBFloat16Weighted to ClickHouse, enabling weighted approximate quantile calculation using the BFloat16 data type.

Why it matters

This feature provides users with a memory-efficient and fast method for calculating approximate weighted quantiles by utilizing the BFloat16 format. It solves the problem of high memory consumption in quantile computations while allowing weighted inputs, which are important for many analytical use cases.

How to use it

Use the new aggregate function quantileBFloat16Weighted in your queries similarly to other weighted quantile functions, for example:

SELECT quantileBFloat16Weighted(value, weight) FROM table;