v.1.1.54310New Feature
Added sumWithOverflow Aggregate Function
Added the sumWithOverflow aggregate function.
Why it matters
The sumWithOverflow function was created to address the problem of overflow errors during aggregation of large numeric values in ClickHouse. It allows summing numbers with overflow by wrapping the result around instead of throwing an error, enabling users to work with large data sets where overflow might occur and maintain query stability.How to use it
Use the sumWithOverflow aggregate function in your queries in the same way as the standard sum function. For example:SELECT sumWithOverflow(column_name) FROM table_nameThis will calculate the sum of values in
column_name and if overflow occurs, it will wrap around without failing the query.