[CASSANDRA-5920] Allow secondary indexed columns to be used with IN operator

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Component/s: Feature/2i Index
• Labels: cql
• Assignee: Unassigned
• Reporter: David Semeria
• Created: 22/Aug/13 12:17
• Updated: 16/Apr/19 09:32
• Resolved: 02/Sep/14 13:25

Description

Related to https://issues.apache.org/jira/browse/CASSANDRA-4709

Using a secondary indexed column we get: Cannot use IN operator on column not part of the PRIMARY KEY
But with any other than the first element of a composite primary key we get: PRIMARY KEY part [COLUMN] cannot be restricted by IN relation

This is a pity, because one of the main attractions of CQL over the thrift API is the ability to do OR filtering on the node rather than the client

Issue Links

• duplicates: CASSANDRA-4386 Allow cql to use the IN syntax on secondary index values