v.18.16Improvement

Added Optional Slot Size Parameter to timeSlots Function

Added an optional parameter: the slot size for the timeSlots function. Kirill Shvakov
Added an optional parameter to the timeSlots function that allows specifying the slot size.

Why it matters

This feature enables users to customize the duration of each time slot in the timeSlots function, providing greater flexibility in time series data analysis and aggregation by controlling the granularity of the time intervals.

How to use it

Use the timeSlots function with the optional slot size parameter to define the desired interval duration. For example:

SELECT timeSlots(timestamp_column, INTERVAL 10 MINUTE) AS slots
FROM table

Here, INTERVAL 10 MINUTE sets the slot size to 10 minutes.