cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From S Ahmed <sahmed1...@gmail.com>
Subject Re: key types and grouping related rows together
Date Thu, 15 Jul 2010 21:08:41 GMT
Given a CF like:

Articles : {

   key1 : { title:"some title", body: "this is my article body...", .... },
   key1 : { title:"some title", body: "this is my article body...", .... }
}

Now these articles could be for different websites e.g. www.website1.com,
www.website2.com

If I want to get the latest 10 articles for a given website, how would I
formulate my key to achieve this?

I basically need to understand how to handle multi-tenancy, b/c I will need
to do this for almost all my CF's.

I'm a little stuck here so guidance would be great!


On Thu, Jul 15, 2010 at 4:01 PM, S Ahmed <sahmed1020@gmail.com> wrote:

> Benjamin,
>
> Ah, thanks for clarifying that.
>
> key sorting is changing in .7 I believe to support a binary array?
>
> On Thu, Jul 15, 2010 at 3:26 PM, Benjamin Black <b@b3k.us> wrote:
>
>> Keys are always sorted (in 0.6) as UTF8 strings.  The CompareWith
>> applies to _columns_ within rows, _not_ to row keys.
>>
>> On Wed, Jul 14, 2010 at 1:44 PM, 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