How to get a list of items when using cassandra
Posted
by Blankman
on Stack Overflow
See other posts from Stack Overflow
or by Blankman
Published on 2010-04-01T18:33:27Z
Indexed on
2010/04/02
15:23 UTC
Read the original article
Hit count: 388
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)
© Stack Overflow or respective owner