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.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 <eev...@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 >> eev...@rackspace.com >> >> > > >
