Hello all! I'm new to Cassandra and the list. Still learning and testing basic stuff. I've got a couple of questions which I'm hoping you could help me with.
I'm currently using Cassandra 1.1.1 and CQL Spec 3. My schema consists of a table which represents a user list with with their according properties (country, last_login_date, email, birthdate, name, etc). I've created a composite key on the columns I always query (country and last_login_date [plus email as the unique part of the key]). If I understand correctly, this generates a wide row Columnfamily where the partition key is the country and the remaining parts of the composite (last_login_date and email) are used for clustering the data... basically each row will represent a country, and each column of a particular row will represent the data of a single user. What I need querying this Columnfamily is a random list of X users from Y country which have logged in in the last Z months. So... 1) Is there an approach to randomly getting a User? Right now I'm doing all this in the receiving end... I retrieve all the corresponding Users and then select a random portion of them. 2) Unless I'm missing something there's now way to page a query using CQL. Some of my queries returns a high volume of data and I don't have enough RAM. Do I have to use the Thrift API or are there other high level libraries which I could use (I'm using Ruby so I'm looking into Twitter's Cassandra gem but I've not found yet a way to do this with it) Thanks in advance. Hope I made myself understood... English is not my primary language :) Best, -- Bruno Di Pentima Santa Fe, Argentina
