v.21.8New Feature
Support additional numeric types in mapAdd and mapSubtract functions
SupportMapandUInt128,Int128,UInt256,Int256types inmapAddandmapSubtractfunctions. #25596 (Ildus Kurbangaliev).
Why it matters
This feature enhances the functionality ofmapAdd 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 usemapAdd 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.