v.19.8New Features

Support Decimal Types in Functions: Quantile, Quantiles, Median, Quantileexactweighted, Quantilesexactweighted, Medianexactweighted

Support Decimal types in functions: quantile, quantiles, median, quantileExactWeighted, quantilesExactWeighted, medianExactWeighted. #5304 (Artem Zuikov)
Support for Decimal data types in quantile-related aggregate functions including quantile, quantiles, median, quantileExactWeighted, quantilesExactWeighted, and medianExactWeighted.

Why it matters

This feature addresses the limitation where quantile functions did not support Decimal types. By enabling Decimal type support, it allows users to perform accurate quantile calculations on precise decimal numeric data, improving analytical capabilities and result precision.

How to use it

Users can directly apply the quantile functions to columns with Decimal types in their queries without additional configuration. For example:

SELECT <code>quantile</code>(decimal_column) FROM table;