Details
-
New Feature
-
Status: Resolved
-
Normal
-
Resolution: Fixed
-
None
Description
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;
InvalidRequest: Error from server: code=2200 [Invalid query] message="IN restrictions are not supported on indexed columns"
cqlsh:ks1>
