cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dikang Gu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-14344) Support the IN restrictions on indexed columns
Date Sat, 24 Mar 2018 19:28:00 GMT
Dikang Gu created CASSANDRA-14344:
-------------------------------------

             Summary: Support the IN restrictions on indexed columns
                 Key: CASSANDRA-14344
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14344
             Project: Cassandra
          Issue Type: New Feature
            Reporter: Dikang Gu


Support IN filter query like this:

 
CREATE TABLE ks1.t1 (
    key int,
    col1 int,
    col2 int,
    value int,
    PRIMARY KEY (key, col1, col2)
) WITH CLUSTERING ORDER BY (col1 ASC, col2 ASC)
 
cqlsh:ks1> select * from t1 where key = 1 and col2 in (1) allow filtering;
 
 key | col1 | col2 | value
-----+------+------+-------
   1 |    1 |    1 |     1
   1 |    2 |    1 |     3
 
(2 rows)
cqlsh:ks1> select * from t1 where key = 1 and col2 in (1, 2) allow filtering;
*{color:#ff0000}InvalidRequest: Error from server: code=2200 [Invalid query] message="IN restrictions
are not supported on indexed columns"{color}*
cqlsh:ks1>



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message