cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "R. Verlangen" <>
Subject Re: Counters and Top 10
Date Thu, 22 Dec 2011 14:46:17 GMT
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 <>

> 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

View raw message