[ https://issues.apache.org/jira/browse/CASSANDRA-4762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne updated CASSANDRA-4762: ---------------------------------------- Summary: Support IN clause for any clustering key (was: Support multiple OR clauses for CQL3 Compact storage) > Support IN clause for any clustering key > ---------------------------------------- > > Key: CASSANDRA-4762 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4762 > Project: Cassandra > Issue Type: Improvement > Components: Core > Reporter: T Jake Luciani > Assignee: T Jake Luciani > Labels: cql3 > Fix For: 3.0 > > Attachments: 4762-1.txt > > > 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: > {code} > 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') > {code} -- This message was sent by Atlassian JIRA (v6.2#6252)