Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-10707

Add support for Group By to Select statement

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 3.10
    • Component/s: Legacy/CQL
    • Labels:
      None

      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; 
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                blerer Benjamin Lerer
                Reporter:
                blerer Benjamin Lerer
                Authors:
                Benjamin Lerer
                Reviewers:
                Sylvain Lebresne
              • Votes:
                7 Vote for this issue
                Watchers:
                30 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: