In my application, I need to store the total scores/reputation of the users as counters and want to show sorted(by score) lists of users. Also want to implement a name search facility on top of that. Could you suggest any schema to achieve that using cassandra.
I know it is not possible to sort columns in a row by counter values so what are the other strategies to maintain a sorted list (of counters) in cassandra? Could you propose some schema that might be helpful to achieve this ?Or do I need to retrieve thousands of columns each time and do the sorting at application level ?