Re: Re: Sorting in Cassandra

2010-10-06 Thread Matthew Dennis
The SCs are stored on disk in the order defined by the compareWith setting so if you want them back in a different order either someone is sorting them (C*, which doesn't sort them right now, or the client; which doesn't make much of a difference, it's just moving the load around) or you're denorma

Re: R: Re: Sorting in Cassandra

2010-10-06 Thread Aaron Morton
Your sort of right for point two. The comparators you define in the keyspace def are for the names of the columns (or super columns) not their values. So it's not possible to sort by the value of your name column, you'll need to do it client side. The indexing features in 0.7 can sort the value

R: Re: Sorting in Cassandra

2010-10-06 Thread cbert...@libero.it
Aaron, first of all thanks for your time. 1. You cannot return just the super columns, you have to get their sub columns as well. The returned data is ordered, please provide and example of where it is not. I don't know what I did before but now I checked and data are sorted as I expected th

Re: Sorting in Cassandra

2010-10-05 Thread Aaron Morton
1. You cannot return just the super columns, you have to get their sub columns as well. The returned data is ordered, please provide and example of where it is not. 2. Pull back the entire row and filter/sort the columns client side. It's not possible to return columns of the same name from differe