cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "T Jake Luciani (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-4762) Support multiple OR clauses for CQL3 Compact storage
Date Fri, 30 Nov 2012 21:46:00 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-4762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

T Jake Luciani updated CASSANDRA-4762:
--------------------------------------

    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:

{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}



  was:
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}



    
> 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
>            Assignee: T Jake Luciani
>              Labels: cql3
>             Fix For: 1.2.1
>
>         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 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

Mime
View raw message