When utilizing a nosql type datastore like Cassandra, how does one return an effect set with different column?
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.