We gave this a try in https://issues.apache.org/jira/browse/CASSANDRA-2591 -- it turns out it's not a good fit for the CQL QueryProcessor. We really need to be able to push more complex queries to the index nodes (https://issues.apache.org/jira/browse/CASSANDRA-1598).
So, we would still like to do this eventually but probably not soon because of the difficulty involved. On Tue, Jun 14, 2011 at 7:08 AM, Bill <b...@dehora.net> wrote: > I was wondering if there are plans for (or any interest in) an IN operator > for CQL/Secondary Indexes? > > I have a use case to pull back N keys on an index and rather than perform N > selects would like to do this > > SELECT ... WHERE KEY = keyname AND colname IN [val1,,..] > > Bill > > > -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com
