v.1.1.54337New Feature

Added sumKahan Aggregate Function

Official CH changelog text
Added the sumKahan aggregate function.
Added the sumKahan aggregate function, which implements a numerically stable summation algorithm to reduce floating-point errors during aggregation.

Why it matters

The sumKahan function was created to solve the problem of floating-point precision loss when summing large datasets. It improves accuracy by compensating for small errors that accumulate in standard summation, providing more reliable and precise aggregated results for analytic queries.

How to use it

Use the sumKahan aggregate function in SQL queries similar to other aggregate functions. For example:

SELECT sumKahan(column_name) FROM table_name

This will return the sum of the specified column with improved numerical stability.
PreviousNext