[CASSANDRA-18867] Document GROUP BY time interval feature

• Type: Task
• Status: Triage Needed
• Priority: Normal
• Resolution: Unresolved
• Component/s: Documentation/Website
• Labels: lhf
• Complexity: Low Hanging Fruit
• Platform: All
• Assignee: Unassigned
• Reporter: Paulo Motta
• Created: 19/Sep/23 18:40
• Updated: 19/Sep/23 18:41

Description

It looks like the aggregation by time range feature added by CASSANDRA-11871 was not added to the documentation.

Example:

SELECT pk, date, floor(time, 5m), min(v), max(v), count(v) FROM table GROUP BY pk, date, floor(time, 5m)

Issue Links

• relates to: CASSANDRA-11871 Allow to aggregate by time intervals