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

Enable SASI index for collections

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Low
    • Resolution: Unresolved
    • None
    • Legacy/CQL

    Description

      This is a follow up ticket for post Cassandra 3.4 SASI integration.

      Right now it is possible with standard Cassandra 2nd index to:

      1. index list and set elements ( WHERE list CONTAINS xxx)
      2. index map keys ( WHERE map CONTAINS KEYS 'abc' )
      3. index map entries ( WHERE map['key']=value)

      It would be nice to enable these features in SASI too.

      With regard to tokenizing, we might want to allow wildcards (%) with the CONTAINS syntax as well as with index map entries. Ex:

      • WHERE list CONTAINS 'John%'
      • WHERE map CONTAINS KEY '%an%'
      • WHERE map['key'] LIKE '%val%'

      /cc xedin rustyrazorblade jkrupan

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              doanduyhai DuyHai Doan
              Votes:
              5 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated: