v.21.1Improvements
Array Aggregation Functions Support for Int128, Int256, and UInt256
Array aggregationarrayMin,arrayMax,arraySum,arrayAvgsupport forInt128,Int256,UInt256. #18147 (Maksim Kita).
Why it matters
This feature enables users to perform array aggregations on very large integer types, expanding analytical capabilities and allowing more precise and efficient calculations when working with 128-bit and 256-bit integers in arrays.How to use it
Simply use the array aggregation functionsarrayMin, arrayMax, arraySum, or arrayAvg on arrays of types Int128, Int256, or UInt256 as you would with other numeric types in your SELECT queries.