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

Secondary indexing of map keys

    XMLWordPrintableJSON

    Details

      Description

      CASSANDRA-4511 started adding secondary indexing for collections, but didn't wired map key indexing because this requires generalizing a bit the 2ndary index API to support 2 indexes on the same column. And since that's not entirely related to the initial problem of CASSANDRA-4511, let's tackle this last part here.

      I'll note that one other is the syntax. For selection, I propose

      SELECT * FROM foo WHERE myMap CONTAINS KEY 'bar';
      

      (but that assumes we use CONTAINS in CASSANDRA-4511, if we use IN, we'll need something else)

      For declaring indexes I'm less inspired. We could have something like

      CREATE INDEX ON foo(myMap KEYS)
      

      but maybe someone has a better idea?

        Attachments

        1. 6383.txt
          12 kB
          Sylvain Lebresne

          Issue Links

            Activity

              People

              • Assignee:
                slebresne Sylvain Lebresne
                Reporter:
                slebresne Sylvain Lebresne
                Authors:
                Sylvain Lebresne
                Reviewers:
                Aleksey Yeschenko
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: