v.23.4Improvement
Functions Enhanced for Wide Integer Support in ClickHouse
Functions "arrayDifferenceSupport()", "arrayCumSum()" and "arrayCumSumNonNegative()" now support input arrays of wide integer types (U)Int128/256. #48866 (cluster).
Why it matters
This feature extends the functionality of three array processing functions to handle wider integer types, enabling users to perform array difference and cumulative sum operations on arrays containing 128-bit and 256-bit integers. It solves the problem of limited type support for these functions, increasing their applicability and allowing users to work with large integer data efficiently.How to use it
Users can directly apply the functionsarrayDifferenceSupport(), arrayCumSum(), and arrayCumSumNonNegative() on arrays of types Int128, UInt128, Int256, or UInt256 without any additional configuration or changes.