You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Benjamin Lerer (JIRA)" <ji...@apache.org> on 2015/08/03 12:26:04 UTC

[jira] [Created] (CASSANDRA-9958) Add support for the IN operator in secondary index queries

Benjamin Lerer created CASSANDRA-9958:
-----------------------------------------

             Summary: Add support for the IN operator in secondary index queries
                 Key: CASSANDRA-9958
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9958
             Project: Cassandra
          Issue Type: Improvement
            Reporter: Benjamin Lerer
            Assignee: Benjamin Lerer
            Priority: Minor


On a table like:
{code}
CREATE Table t (a int , b int, c text, PRIMARY KEY (a, b));
CREATE INDEX ON t (c);
{code}

A query like 
{code}
SELECT * FROM t WHERE a IN (1, 2) AND b  > 3 AND c= 'test' ALLOW FILTERING;
{code}
is not supported. 

If the user want to paginate over the result of such query, issuing 2 queries is not a good option.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)