Re: How scalable are automatic secondary indexes in Cassandra 0.7?

2011-02-23 Thread Stu Hood
In practice, local secondary indexes scale to {RF * the limit of a single machine} for -low cardinality- values (ex: users living in a certain state) since the first node is likely to be able to answer your question. This also means they are good for performing filtering for analytics. On the othe

How scalable are automatic secondary indexes in Cassandra 0.7?

2011-02-22 Thread Piotr J.
Hi, As far as I understand automatic secondary indexes are generated for node local data. In this case query by secondary index involve all nodes storing part of column family to get results (?) so (if i am right) if data is spread across 50 nodes then 50 nodes are involved in single query? How f

Re: indexes in cassandra

2011-01-23 Thread Maxim Potekhin
Jonathan, what's your comment to the other thread, where the developers state that indices do not commute? On 1/23/2011 4:30 PM, Jonathan Ellis wrote: They are returned in token order, which is the same as key order for OPP. On Sun, Jan 23, 2011 at 2:11 AM, Shay Assulin wrote: hi, I am usi

Re: indexes in cassandra

2011-01-23 Thread Jonathan Ellis
They are returned in token order, which is the same as key order for OPP. On Sun, Jan 23, 2011 at 2:11 AM, Shay Assulin wrote: > > hi, > > I am using get_indexed_slices to get rows from Cassandra > Does Cassandra returns the rows with some order? I am using OPP and it seems > that the rows are or

indexes in cassandra

2011-01-23 Thread Shay Assulin
hi, I am using get_indexed_slices to get rows from Cassandra Does Cassandra returns the rows with some order? I am using OPP and it seems that the rows are ordered 10x