[jira] [Commented] (CASSANDRA-4762) Support IN clause for any clustering column

["Benjamin Lerer (JIRA)" <ji...@apache.org>]

    [ 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)