You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sylvain Lebresne (JIRA)" <ji...@apache.org> on 2014/04/18 18:26:17 UTC
[jira] [Updated] (CASSANDRA-4762) Support IN clause for any
clustering key
[ 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)