sumKahan

Introduced in: v1.1.0 Calculates the sum of the numbers with Kahan compensated summation algorithm. Slower than sum function. The compensation works only for Float types. Syntax

sumKahan(x)

Arguments

x — Input value. Integer or Float or Decimal

Returned value Returns the sum of numbers. (U)Int* or Float* or Decimal Examples Demonstrating precision improvement with Kahan summation

Query

SELECT sum(0.1), sumKahan(0.1) FROM numbers(10);

Response

┌───────────sum(0.1)─┬─sumKahan(0.1)─┐
│ 0.9999999999999999 │             1 │
└────────────────────┴───────────────┘

Last modified on June 23, 2026

sumMapTotals one or more `value` arrays according to the keys specified in the `key` array. Returns a tuple of arrays: keys in sorted order, followed by values summed for the corresponding keys without overflow.

​sumKahan

sumKahan