v.21.7New Feature

Add aggregate function segmentLengthSum

Add aggregate function segmentLengthSum. #24250 (flynn).
Added a new aggregate function segmentLengthSum to ClickHouse.

Why it matters

This function calculates the sum of the lengths of segments, providing users an efficient way to aggregate segment length data. It is useful for scenarios where users need to compute total segment lengths in datasets, enhancing analytical capabilities.

How to use it

Use the segmentLengthSum function in your SELECT queries as a standard aggregate function. For example:

SELECT segmentLengthSum(column_name) FROM table_name;