Re: Range query ordering with CQL JDBC

2011-07-18 Thread Matthieu Nahoum
Aaron, thanks for the reply. I think what I encounter is exactly this problem! I'll try the suggestions, or switch away from the random partitioner. Cordially, Matthieu Nahoum On Sun, Jul 17, 2011 at 5:50 PM, aaron morton aa...@thelastpickle.comwrote: You are probably seeing this

Re: Range query ordering with CQL JDBC

2011-07-18 Thread samal
I haven't used CQL functionality much, but thirft client I think what I encounter is exactly this problem! If you want to query over key, you can index keys to other CF, get the column names (that is key of other CF ). and then query actual CF with keys. switch away from the random partitioner.

Re: Range query ordering with CQL JDBC

2011-07-17 Thread aaron morton
You are probably seeing this http://wiki.apache.org/cassandra/FAQ#range_rp Row keys are not ordered by their key, they are ordered by the token created by the partitioner. If you still think there is a problem provide an example of the data your are seeing and what you expected to see.

Re: Range query ordering with CQL JDBC

2011-07-15 Thread Eric Evans
On Thu, 2011-07-14 at 11:07 -0500, Matthieu Nahoum wrote: I am trying to range-query a column family on which the keys are epochs (similar to the output of System.currentTimeMillis() in Java). In CQL (Cassandra 0.8.1 with JDBC driver): SELECT * FROM columnFamily WHERE KEY '130920500';

Re: Range query ordering with CQL JDBC

2011-07-15 Thread Matthieu Nahoum
Hi Eric, I am using the default partitioner, which is the RandomPartitioner I guess. The key type is String. Are Strings ordered by lexicographic rules? Thanks On Fri, Jul 15, 2011 at 12:04 PM, Eric Evans eev...@rackspace.com wrote: On Thu, 2011-07-14 at 11:07 -0500, Matthieu Nahoum wrote: