[CASSANDRA-4762] Support IN clause for any clustering column

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.0 beta 1
• Component/s: Legacy/CQL
• Labels: cql docs
• Assignee: Benjamin Lerer
• Reporter: T Jake Luciani

Authors

Benjamin Lerer

Reviewers

Tom Hobbs

• Created: 04/Oct/12 15:07
• Updated: 16/Apr/19 09:32
• Resolved: 17/Sep/14 18:58

Description

Given CASSANDRA-3885

It seems it should be possible to store multiple ranges for many predicates even the inner parts of a composite column.

They could be expressed as a expanded set of filter queries.

example:

CREATE TABLE test (
       name text,
       tdate timestamp,
       tdate2 timestamp,
       tdate3 timestamp,
       num double,
       PRIMARY KEY(name,tdate,tdate2,tdate3)
     ) WITH COMPACT STORAGE;

SELECT * FROM test WHERE 
  name IN ('a','b') and
  tdate IN ('2010-01-01','2011-01-01') and
  tdate2 IN ('2010-01-01','2011-01-01') and
  tdate3 IN ('2010-01-01','2011-01-01') 

Issue Links

• blocks: CASSANDRA-5086 MultiSlice bug in SimpleBlockFetcher
• is duplicated by: CASSANDRA-6318 IN predicates on non-primary-key columns (%s) is not yet supported
• is duplicated by: CASSANDRA-7054 Enable allow filtering IN clause on compound cluster key