[CASSANDRA-9958] Add support for the IN operator in secondary index queries

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Duplicate
• Component/s: Feature/2i Index
• Assignee: Benjamin Lerer
• Reporter: Benjamin Lerer

Authors

Benjamin Lerer

• Created: 03/Aug/15 10:26
• Updated: 16/Apr/19 09:31
• Resolved: 20/Aug/15 11:35

Description

On a table like:

CREATE Table t (a int , b int, c text, PRIMARY KEY (a, b));
CREATE INDEX ON t (c);

A query like

SELECT * FROM t WHERE a IN (1, 2) AND b  > 3 AND c= 'test' ALLOW FILTERING;

is not supported.

If the user want to paginate over the result of such query, issuing 2 queries is not a good option.

Issue Links

• duplicates: CASSANDRA-4386 Allow cql to use the IN syntax on secondary index values
• is related to: CASSANDRA-9659 Better messages/protection against bad paging state