Hi, 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
