cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "" <>
Subject How would you model that?
Date Fri, 08 Nov 2013 11:10:31 GMT
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

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...


View raw message