v.19.3New Features

Implement Summapfiltered in Order to Be Able to Limit the Number of Keys for Which Values Will Be Summed by Summap

Implement sumMapFiltered in order to be able to limit the number of keys for which values will be summed by sumMap. #4129 (Léo Ercolanelli)
Introduces the sumMapFiltered aggregate function, which allows summing values for a limited subset of keys, enhancing the existing sumMap functionality.

Why it matters

To provide users with the ability to restrict the aggregation to specific keys when using map-based summation, reducing overhead and focusing the aggregation on relevant data keys.

How to use it

Use the sumMapFiltered function in your queries by specifying a filter condition that limits the keys to be included in the sum. This works similarly to sumMap but applies filtering to the keys beforehand.