v.21.7New Feature
Add aggregate function segmentLengthSum
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 thesegmentLengthSum function in your SELECT queries as a standard aggregate function. For example:SELECT segmentLengthSum(column_name) FROM table_name;