T Jake Luciani created CASSANDRA-4762:
-----------------------------------------

             Summary: Support multiple OR clauses for CQL3 Compact storage
                 Key: CASSANDRA-4762
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4762
             Project: Cassandra
          Issue Type: Improvement
          Components: Core
            Reporter: T Jake Luciani
             Fix For: 1.2.0


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(key,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') and
  num > 1.0

{code}



--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to