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).
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
UsetimeSeriesRange(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.