incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benoit Perroud <ben...@noisette.ch>
Subject Re: Counters and Top 10
Date Sun, 25 Dec 2011 09:19:59 GMT
With Composite Column Name, you can even have column composed of sore
(int) and userid (uuid or whatever). Empty column value to avoid
repeating user UUID.


2011/12/22 R. Verlangen <robin@us2.nl>:
> I would suggest you to create a CF with a single row (or multiple for
> historical data) with a date as key (utf8, e.g. 2011-12-22) and multiple
> columns for every user's score. The column (utf8) would then be the score +
> something unique of the user (e.g. hex representation of the TimeUUID). The
> value would be the TimeUUID of the user.
>
> By default columns will be sorted and you can perform a slice to get the top
> 10.
>
> 2011/12/14 cbertu81@libero.it <cbertu81@libero.it>
>
>> Hi all,
>> I'm using Cassandra in production for a small social network (~10.000
>> people).
>> Now I have to assign some "credits" to each user operation (login, write
>> post
>> and so on) and then beeing capable of providing in each moment the top 10
>> of
>> the most active users. I'm on Cassandra 0.7.6 I'd like to migrate to a new
>> version in order to use Counters for the user points but ... what about
>> the top
>> 10?
>> I was thinking about a specific ROW that always keeps the 10 most active
>> users
>> ... but I think it would be heavy (to write and to handle in thread-safe
>> mode)
>> ... can counters provide something like a "value ordered list"?
>>
>> Thanks for any help.
>> Best regards,
>>
>> Carlo
>>
>>
>



-- 
sent from my Nokia 3210

Mime
View raw message