incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Range query ordering with CQL JDBC
Date Sun, 17 Jul 2011 22:50:21 GMT
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. 

Cheers


-----------------
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com

On 16 Jul 2011, at 06:09, Matthieu Nahoum wrote:

> 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 <eevans@rackspace.com> wrote:
> 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 > '1309205000000';
> >
> > I can't get to have a result that make sense, it always returns wrong
> > timestamps. So I must make an error somewhere in the way I input the
> > querying value. I tried in clear (like above), in hexadecimal, etc.
> >
> > What is the correct way of doing this? Is it possible that my key is
> > too long?
> 
> What partitioner are you using?  What is the key type?
> 
> --
> Eric Evans
> eevans@rackspace.com
> 
> 
> 
> 
> -- 
> ---------------------------------------
> Engineer at NAVTEQ
> Berkeley Systems Engineer '10
> ENAC Engineer '09
> 
> 151 N. Michigan Ave.
> Appt. 3716
> Chicago, IL, 60601
> USA
> Cell: +1 (510) 423-1835
> 
> http://www.linkedin.com/in/matthieunahoum
> 


Mime
View raw message