How would you model that?

2013-11-08 Thread pavli...@gmail.com
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 se

Cannot restrict PRIMARY KEY part bucket_id by IN relation as a collection is selected by the query

2013-11-07 Thread pavli...@gmail.com
Hey guys, just started to learn Cassandra recently, got a simple (hopefully) question on querying. There's a table with composite primary key - mdid and bucket_id. So I assume mdid is going to be a partition key and bucket_id is a clustering key. There're also two more columns to hold a text and a