v.21.8New Feature

Support additional numeric types in mapAdd and mapSubtract functions

Support Map and UInt128, Int128, UInt256, Int256 types in mapAdd and mapSubtract functions. #25596 (Ildus Kurbangaliev).
Support for Map and extended integer types UInt128, Int128, UInt256, and Int256 has been added to the mapAdd and mapSubtract functions.

Why it matters

This feature enhances the functionality of mapAdd and mapSubtract by allowing them to operate on complex data types such as Map and large integer types. It addresses the need to perform arithmetic and aggregation operations on these types within maps, offering users more flexibility and expressive power when manipulating data.

How to use it

Users can now directly use mapAdd and mapSubtract functions with columns or values of types Map, UInt128, Int128, UInt256, and Int256 without any additional configuration. Simply apply these functions in SELECT queries or other SQL statements as usual.