Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 2 Sep 2014 12:01:21 +0000 (UTC)
From: "Benjamin Lerer (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12610343.1349363229000.8879.1409659281775@Atlassian.JIRA>
In-Reply-To: <JIRA.12610343.1349363229000@Atlassian.JIRA>
References: <JIRA.12610343.1349363229000@Atlassian.JIRA>
 <JIRA.12610343.1349363229334@arcas>
Subject: [jira] [Commented] (CASSANDRA-4762) Support IN clause for any
 clustering column
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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