But Timo, this is even more mysterious! If both conditions are met, at least
something must be returned in the second query. Have you tried this in CLI?
That would allow you to at least alleviate client concerns.
On 1/21/2011 10:38 AM, Timo Nentwig wrote:
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...
