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: [email protected]
For additional commands, e-mail: [email protected]
