How to get a list of items when using cassandra
- by Blankman
When using a nosql type datastore like Cassandra, how would you return a result set based on a column?
e.g.
SELECT *
FROM Articles
WHERE category='blah'
ORDER BY datetime DESC
is this something that you would store in a sql db and then pull the data from cassandra? Or can cassandra handle this type of query? (assuming millions of rows in a db)
From what I understand, cassandra is great at key based lookups, confused if it can and should be used for getting a list of data back and paging that data also (and if it is highly performant)