[CASSANDRA-6318] IN predicates on non-primary-key columns (%s) is not yet supported

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Labels: cql3
• Severity: Normal
• Assignee: Unassigned
• Reporter: Sergey Nagaytsev
• Created: 08/Nov/13 12:14
• Updated: 16/Apr/19 09:32
• Resolved: 10/Dec/13 16:56

Description

Query:
SELECT * FROM post WHERE blog IN (1,2) AND author=3 ALLOW FILTERING – contrived

Error: IN predicates on non-primary-key columns (blog) is not yet supported

Please either implement, set milestone or say will never be implemented !

P.S. Did search, seemingly found no issue/plan related to it. Maybe CASSANDRA-6048 ?

P.S.2 What is recommended workaround for this ? Manual index tables, what are design guidelines for them ?

Issue Links

• duplicates: CASSANDRA-4762 Support IN clause for any clustering column
• duplicates: CASSANDRA-4386 Allow cql to use the IN syntax on secondary index values