v.18.14Improvement

Support for Date, DateTime, UUID, and Decimal Types in sumMap Aggregate Function

Support for the Date, DateTime, UUID, and Decimal types as a key for the sumMap aggregate function. #3281
Support for the Date, DateTime, UUID, and Decimal data types as keys in the sumMap aggregate function.

Why it matters

This feature extends the usability of the sumMap aggregate function by enabling it to accept additional key data types. Previously limited to fewer types, this enhancement allows users to perform aggregate calculations with keys of types Date, DateTime, UUID, and Decimal, thus improving versatility and analytical possibilities within ClickHouse.

How to use it

Users can now directly use the sumMap aggregate function with keys of types Date, DateTime, UUID, and Decimal without any additional configuration. Simply specify these data types as the key column in the sumMap aggregation within their SQL queries.