Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-24 Thread Aaron Morton
Maxim,Off the top of my head I'm not aware of any limitations in the indexes (other than the operators). This will give me a reason to dig into the code further and do some more reading Can you provide some more info on the system (in another thread) and the group may be able to help with the

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-24 Thread Aaron Morton
Timo,Below is a test I did via the CLI, it worked as expected for me. If you're still experiencing the problem could you try to repro it like this ?Paste this into the CLI to setup the schema and datacreate keyspace index_test with replication_factor = 1;use index_test;create column family Indexed

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread Aaron Morton
Timo / Maxim Could you provide a more concrete example and I'll try to look into it tonight. Cheers Aaron On 22/01/2011, at 5:01 AM, Maxim Potekhin potek...@bnl.gov wrote: Well it does sound like a bug in Cassandra. Indexes MUST commute. I really need this functionality, it's a show

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread Maxim Potekhin
Aaron -- thanks! I don't have examples like Timo. But, I'm keen to use multiple indices over a database of 300M rows. Maxim On 1/23/2011 3:28 PM, Aaron Morton wrote: Timo / Maxim Could you provide a more concrete example and I'll try to look into it tonight. Cheers Aaron On 22/01/2011,

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread David McNelis
Silly question, M us thousand or million? In print, thousand is M, fwiw Sent from my Droid On Jan 23, 2011 7:26 PM, Maxim Potekhin potek...@bnl.gov wrote: Aaron -- thanks! I don't have examples like Timo. But, I'm keen to use multiple indices over a database of 300M rows. Maxim On

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-23 Thread Maxim Potekhin
Not silly at all, sorry for eschewing clarity in Latin usage: millions, not thousands. Here in the States, we typically use M for millions. Anyhow, my system generates 1 million (large) records every three days, Cheers, Maxim On 1/23/2011 8:35 PM, David McNelis wrote: Silly question, M us

Multiple indexes - how does Cassandra handle these internally?

2011-01-21 Thread buddhasystem
-incubator-apache-org.3065146.n2.nabble.com/Multiple-indexes-how-does-Cassandra-handle-these-internally-tp5947533p5947533.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-21 Thread Timo Nentwig
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

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-21 Thread Maxim Potekhin
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

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-21 Thread Timo Nentwig
On Jan 21, 2011, at 16:46, Maxim Potekhin wrote: 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. I did this on the CLI only so

Re: Multiple indexes - how does Cassandra handle these internally?

2011-01-21 Thread Maxim Potekhin
Well it does sound like a bug in Cassandra. Indexes MUST commute. I really need this functionality, it's a show stopper for me... On 1/21/2011 10:56 AM, Timo Nentwig wrote: On Jan 21, 2011, at 16:46, Maxim Potekhin wrote: But Timo, this is even more mysterious! If both conditions are met, at