[jira] [Created] (CASSANDRA-11182) Enable SASI index for collections and static columns

["DOAN DuyHai (JIRA)" <ji...@apache.org>]

DOAN DuyHai created CASSANDRA-11182:
---------------------------------------

             Summary: Enable SASI index for collections and static columns
                 Key: CASSANDRA-11182
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11182
             Project: Cassandra
          Issue Type: Improvement
          Components: CQL
            Reporter: DOAN DuyHai
            Priority: Minor


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]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)