cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Timo Nentwig <>
Subject Re: Multiple indexes - how does Cassandra handle these internally?
Date Fri, 21 Jan 2011 15:38:27 GMT
On Jan 21, 2011, at 13:55, buddhasystem wrote:

> if I use multiple secondary indexes in the query, what will Cassandra do?
> Some examples say it will index on first EQ and then loop on others. Does it
> ever do a proper index product to avoid inner loops?

Just asked the same question on the hector-dev group a few minutes ago. Seems indeed to be
the case that cassandra only uses 1 index. At least this would make sense narrowing down issues
I have that

 get foo where col1=cond1 and col2=cond2

works while flipping conditions 

 get foo where col2=cond2 and col1=cond1

returns no results no more.

Unfortunately nobody around here seems to care...
View raw message