Added sumMap Function for Array Summation

Published: November 25, 2025

Added the sumMap aggregate function for calculating the sum of arrays, similar to SummingMergeTree.

Added the sumMap aggregate function to efficiently calculate the sum of arrays, extending the aggregation capabilities similar to SummingMergeTree.

Why it matters

The sumMap function was created to address the need for summing elements within arrays across multiple rows in an aggregated manner. This is valuable for users who work with nested or array data structures and need to compute combined sums of corresponding array elements efficiently, improving performance and simplifying queries.

How to use it

Use the sumMap aggregate function in queries to aggregate and sum arrays element-wise. For example, SELECT sumMap(array_column) FROM table; will calculate the element-wise sum of arrays in the specified column across all rows.