cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthieu Nahoum <matthieu.nah...@gmail.com>
Subject Re: Range query ordering with CQL JDBC
Date Mon, 18 Jul 2011 06:27:59 GMT
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 <aaron@thelastpickle.com>wrote:

> 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
>>
>>
>
>
>

Mime
View raw message