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)
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;