cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Schubert Zhang <zson...@gmail.com>
Subject Re: key types and grouping related rows together
Date Thu, 15 Jul 2010 02:20:20 GMT
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>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> 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