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
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!
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!
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!
--
*Franc Carter* | Systems architect | Sirca Ltd
marc.zianideferra...@sirca.org.au
franc.car...@sirca.org.au | www.sirca.org.au
Tel: +61 2 8355