v.18.14Improvement
Support for Date, DateTime, UUID, and Decimal Types in sumMap Aggregate Function
Support for theDate,DateTime,UUID, andDecimaltypes as a key for thesumMapaggregate function. #3281
Why it matters
This feature extends the usability of thesumMap 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 thesumMap 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.