incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sielski <siel...@man.poznan.pl>
Subject Error: Unable to search across multiple secondary index types
Date Fri, 15 Nov 2013 09:22:08 GMT
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
Mime
View raw message