incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thorvaldsson Justus <justus.thorvalds...@svenskaspel.se>
Subject SV: key types and grouping related rows together
Date Thu, 15 Jul 2010 06:44:31 GMT
Dont forget you can make your own sorting algorithm.
Here is a nice tutorial for that.
http://www.sodeso.nl/?p=421

Justus

Från: Schubert Zhang [mailto:zsongbo@gmail.com]
Skickat: den 15 juli 2010 04:20
Till: user@cassandra.apache.org
Ämne: Re: key types and grouping related rows together

for your apps, how about this schema:

key: website1123
columnName: UserID
...
On Thu, Jul 15, 2010 at 6:13 AM, Aaron Morton <aaron@thelastpickle.com<mailto:aaron@thelastpickle.com>>
wrote:
The key structure you have should group the keys based on the website There are some differences
between range queries with RP and OPP this article may help
http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-vs-orderpreservingpartitioner/

Aaron

On 15 Jul, 2010,at 08:44 AM, S Ahmed <sahmed1020@gmail.com<mailto:sahmed1020@gmail.com>>
wrote:
Where is the link that describes the various key types and their impact on sorting? (I believe
I read it before, can't seem to find it now).

So my application supports multi-tenants, so I need the keys to represent things like:

website1123 + contentID

or

website3454 + userID

And for range queries, these keys have to be grouped together obviously.

What key type would be best suited for this?


I might have to create a CF that maps the website and its key prefix?


Mime
View raw message