[CASSANDRA-10707] Add support for Group By to Select statement

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.10
• Component/s: Legacy/CQL
• Assignee: Benjamin Lerer
• Reporter: Benjamin Lerer

Authors

Benjamin Lerer

Reviewers

Sylvain Lebresne

• Created: 14/Nov/15 20:36
• Updated: 16/Apr/19 09:30
• Resolved: 04/Aug/16 15:17

Description

Now that Cassandra support aggregate functions, it makes sense to support GROUP BY on the SELECT statements.

It should be possible to group either at the partition level or at the clustering column level.

SELECT partitionKey, max(value) FROM myTable GROUP BY partitionKey;
SELECT partitionKey, clustering0, clustering1, max(value) FROM myTable GROUP BY partitionKey, clustering0, clustering1; 

Issue Links

• depends upon: CASSANDRA-11603 PER PARTITION LIMIT does not work properly for SinglePartition
• depends upon: CASSANDRA-11669 RangeName queries might not return all the results
• is depended upon by: CASSANDRA-11871 Allow to aggregate by time intervals