Hey guys, I need to retrieve a list of distinct users based on their activity datetime. How can I model a table to store that kind of information?
The straightforward decision was this: CREATE TABLE user_activity (user text primary key, ts timeuuid); but it turned out it is impossible to do a select like this: select * from user_activity order by ts; as it fails with "ORDER BY is only supported when the partition key is restricted by an EQ or an IN". How would you model the thing? Just need to have a list of users based on their last activity timestamp... Thanks!