incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erez Efrati <>
Subject Model Question
Date Wed, 24 Mar 2010 20:36:13 GMT

I can't figure out how to use model the following using column family and
the way the columns are sorted (by their name).

Lets say I have a list of users and for each user I wish to display a list
of all the friends he has ordered by the number of messages they sent him so
far (desc from most to least).

I can't see how this is going to work since the columns sorting is always by
the name of the column and not its value. I thought of having a row for each
user and the columns will be the friends that email him. But the column name
needs to be the number of messages to be sorted and the value will be the
friend's user ID. But then, when a friend is sending a message to another
user how do I increment his count of message he sent so far to that user?

How can I model this with Cassandra? Is it possible?

Thanks in advance,

Erez Efrati

View raw message