Added Aggregate Function Timeseriesgroupsum, Which Can Aggregate Different Time Series That Sample Timestamp Not Alignment

Why it matters

These functions solve the problem of aggregating multiple time series that have different sampling timestamps which are not aligned. timeSeriesGroupSum performs linear interpolation between sampling points and sums the series, while timeSeriesGroupRateSum calculates the rate of change in the series before summing. This enables accurate aggregation and rate calculation over disparate time series data, improving analysis and metrics computation.

How to use it

Use the aggregate functions timeSeriesGroupSum and timeSeriesGroupRateSum in your SQL queries to aggregate time series data. For example:

SELECT timeSeriesGroupSum(time_series_column) FROM your_table;

or

SELECT timeSeriesGroupRateSum(time_series_column) FROM your_table;