Hi, I'm modeling some queries in CQL3. I'd like to query first 1 columns for each partitioning keys in CQL3.
For example: create table posts( > author ascii, > created_at timeuuid, > entry text, > primary key(author,created_at) > ); > insert into posts(author,created_at,entry) values > ('john',minTimeuuid('2013-02-02 10:00+0000'),'This is an old entry by > john'); > insert into posts(author,created_at,entry) values > ('john',minTimeuuid('2013-03-03 10:00+0000'),'This is a new entry by john'); > insert into posts(author,created_at,entry) values > ('mike',minTimeuuid('2013-02-02 10:00+0000'),'This is an old entry by > mike'); > insert into posts(author,created_at,entry) values > ('mike',minTimeuuid('2013-03-03 10:00+0000'),'This is a new entry by mike'); And I want results like below. mike,1c4d9000-83e9-11e2-8080-808080808080,This is a new entry by mike > john,1c4d9000-83e9-11e2-8080-808080808080,This is a new entry by john I think that this is what "SELECT FIRST " statements did in CQL2. The only way I came across in CQL3 is "retrieve whole records and drop manually", but it's obviously not efficient. Could you please tell me more straightforward way in CQL3?