v.25.8New Feature

Add two new TimeSeries

Add two new TimeSeries functions: - timeSeriesRange(start_timestamp, end_timestamp, step), - timeSeriesFromGrid(start_timestamp, end_timestamp, step, values),. #85435 (Vitaly Baranov).
Introduces two new TimeSeries functions: timeSeriesRange(start_timestamp, end_timestamp, step) and timeSeriesFromGrid(start_timestamp, end_timestamp, step, values) for generating and manipulating time series data.

Why it matters

These functions enable users to generate time series data points over a specified range with a fixed step interval. timeSeriesRange creates a series of timestamps between a start and end value, while timeSeriesFromGrid produces a time series with corresponding values at each time step. This simplifies time series data preparation and manipulation for analytical queries.

How to use it

Use timeSeriesRange(start_timestamp, end_timestamp, step) to generate a series of timestamps from the start to end timestamps with the specified step interval. Use timeSeriesFromGrid(start_timestamp, end_timestamp, step, values) to create a time series combining the timestamp grid with a corresponding array of values. These functions can be called directly in SQL queries.