cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin Lerer (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4762) Support IN clause for any clustering column
Date Tue, 02 Sep 2014 12:01:21 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-4762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14118116#comment-14118116
] 

Benjamin Lerer commented on CASSANDRA-4762:
-------------------------------------------

Pushed [branch|https://github.com/blerer/cassandra/commits/CASSANDRA-4762] with the fix. 
The fix add a new class CompositesBuilder that can be used to build easily mutiple Composites.
Internally it delegate the task of building the Composite to the CBuilder provided in the
constructor. SelectStatement has been then modified to use this CompositesBuilder in the buildBound
and getRequestedColumns methods.

> Support IN clause for any clustering column
> -------------------------------------------
>
>                 Key: CASSANDRA-4762
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4762
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Core
>            Reporter: T Jake Luciani
>            Assignee: Benjamin Lerer
>              Labels: cql
>             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.3.4#6332)

Mime
View raw message