Re: Composite keys and range queries

2012-03-15 Thread aaron morton
You > want to layout your data per the "Physical representation of the denormalized > timeline rows" diagram. > Where your UUID is the "user_id" from the example, and your priority is the > "tweet_id" > > -Jeremiah > > > From:

Re: Composite keys and range queries

2012-03-14 Thread John Laban
al representation of the > denormalized timeline rows" diagram. > Where your UUID is the "user_id" from the example, and your priority is > the "tweet_id" > > -Jeremiah > > > ------ > *From:* John Laban [j...@pagerduty.com

RE: Composite keys and range queries

2012-03-14 Thread Jeremiah Jordan
UUID is the "user_id" from the example, and your priority is the "tweet_id" -Jeremiah From: John Laban [j...@pagerduty.com] Sent: Wednesday, March 14, 2012 12:37 PM To: user@cassandra.apache.org Subject: Re: Composite keys and range queries Hmm,

Re: Composite keys and range queries

2012-03-14 Thread John Laban
Hmm, now I'm really confused. > This may be of use to you http://www.datastax.com/dev/blog/schema-in-cassandra-1-1 This article is what I actually used to come up with my schema here. In the "Clustering, composite keys, and more" section they're using a schema very similarly to how I'm trying to

Re: Composite keys and range queries

2012-03-14 Thread aaron morton
You are seeing this http://wiki.apache.org/cassandra/FAQ#range_rp The hash for (uuid-1 , p1) may be 100 and the hash for (uuid-1, p2) may be 1 . You cannot do what you want to. Even if you passed a start of (uuid1,) and no finish, you would not only get rows where the key starts with uuid1. Th

Re: Composite keys and range queries

2012-03-13 Thread John Laban
Forwarding to the Cassandra mailing list as well, in case this is more of an issue on how I'm using Cassandra. Am I correct to assume that I can use range queries on composite row keys, even when using a RandomPartitioner, if I make sure that the first part of the composite key is fixed? Any help