v.18.16Improvement
Added Optional Slot Size Parameter to timeSlots Function
Added an optional parameter: the slot size for the timeSlots function. Kirill ShvakovWhy it matters
This feature enables users to customize the duration of each time slot in thetimeSlots function, providing greater flexibility in time series data analysis and aggregation by controlling the granularity of the time intervals.How to use it
Use thetimeSlots 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 tableHere,
INTERVAL 10 MINUTE sets the slot size to 10 minutes.