Re: cql/secondary indexes - select in

2011-06-14 Thread Jonathan Ellis
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

cql/secondary indexes - select in

2011-06-14 Thread Bill
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