When utilizing a nosql type datastore like Cassandra, how does one return an effect set with different column?

e.g.

SELECT *
FROM Articles
WHERE category='blah'
ORDER BY datetime DESC

is something you would store inside a sql db after which pull the information from cassandra? Or can cassandra handle this kind of query? (presuming countless rows inside a db)

From things i understand, cassandra is excellent at key based searches, confused whether it can and really should be utilized to get a listing of information back and paging that data also (and when it's highly performant)

You produce a CF whose secrets are the groups, and whose posts would be the articles for the reason that category. Then research-by-category is simply another research-by-key. Clients like lazyboy will automate this for you personally.