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

allow per-partition LIMIT clause in cql

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 3.6
    • None

    Description

      somewhat related to static columns (#6561) and slicing (#4851), it is desirable to apply a LIMIT on a per-partition rather than per-query basis, such as to retrieve the top (most recent, etc) N clustered values for each partition key, e.g.

      – for each league, keep a ranked list of users
      create table scores (league text, score int, player text, primary key(league, score, player) );

      – get the top 3 teams in each league:
      select * from scores staticlimit 3;

      this currently requires issuing one query per partition key, which is tedious if all the key partition key values are known and impossible if they aren't.

      Attachments

        Issue Links

          Activity

            People

              ifesdjeen Alex Petrov
              jhalliday Jonathan Halliday
              Alex Petrov
              Sylvain Lebresne
              Votes:
              12 Vote for this issue
              Watchers:
              26 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: