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.
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 wrote:
> You are probably seeing this http://wiki.apache.org/cassandra/
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
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 wrote:
> On Thu, 2011-07-14 at 11:07 -0500, Matthieu Nahoum wrote:
> > I am trying to ran
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 > '1309205
Hi,
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';
I can't get to have a result that make sense, it always re