v.18.14Improvement

Support Decimal Data Type in SummingMergeTree Tables

Support for the Decimal data type in SummingMergeTree tables. #3348
Support for the Decimal data type in SummingMergeTree tables.

Why it matters

This feature enables the use of the Decimal data type within SummingMergeTree tables, allowing precise aggregation and summation of decimal values during merges. This solves the problem of handling decimal arithmetic accurately in aggregated data, providing more reliable results for financial and other use cases that require high-precision decimal calculations.

How to use it

To use this feature, create or alter your SummingMergeTree table schema to include columns with the Decimal data type. The built-in merge logic will now correctly sum these decimal columns on data merges without additional configuration.