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

Add support for Group By to Select statement

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 3.10
    • Legacy/CQL
    • 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

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-11603 PER PARTITION LIMIT does not work properly for SinglePartition

          • Normal -
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-11669 RangeName queries might not return all the results

          • Normal -
          • Resolved
          is depended upon by

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-11871 Allow to aggregate by time intervals

          • Normal -
          • Resolved

          Activity

            People

              blerer Benjamin Lerer
              blerer Benjamin Lerer
              Benjamin Lerer
              Sylvain Lebresne
              Votes:
              7 Vote for this issue
              Watchers:
              29 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: