Hello,
I’ve installed Cassandra 2.0.2 and I’m trying to query a cassandra table using
a SELECT statement with two WHERE clauses on columns with secondary indexes but
Cassandra throws an error as in the subject.
It’s easy to reproduce this problem. My table structure is as follows:
CREATE TABLE test (c1 VARCHAR, c2 VARCHAR, c3 VARCHAR, PRIMARY KEY (c1, c2);
CREATE INDEX test_i1 ON test (c2);
CREATE INDEX test_i2 ON test (c3);
Then I execute a simple query on an empty table:
SELECT * FROM test WHERE c2='whatever' AND c3 ='whatever' ALLOW FILTERING;
I would expect an empty response, but instead I get "Request did not complete
within rpc_timeout.” info on cqlsh interface and there is an error in cassandra
logs:
ERROR 09:57:36,394 Exception in thread Thread[ReadStage:35,5,main]
java.lang.RuntimeException: java.lang.RuntimeException: Unable to search across
multiple secondary index types
at
org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1931)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.RuntimeException: Unable to search across multiple
secondary index types
at
org.apache.cassandra.db.index.SecondaryIndexManager.search(SecondaryIndexManager.java:535)
at
org.apache.cassandra.db.ColumnFamilyStore.search(ColumnFamilyStore.java:1649)
at
org.apache.cassandra.db.RangeSliceCommand.executeLocally(RangeSliceCommand.java:135)
at
org.apache.cassandra.service.StorageProxy$LocalRangeSliceRunnable.runMayThrow(StorageProxy.java:1414)
at
org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1927)
Is it a bug or there is a reason why I cannot execute such a query on this
model? I saw an issue https://issues.apache.org/jira/browse/CASSANDRA-5851
which is similar to mine but it’s marked as resolved in 2.0.0 and I’m using the
most recent version.
—
Regards,
Krzysztof Sielski
