When using a nosql-type datastore like Cassandra, how would you return a column-based result set?
eg.
SELECT *
FROM Articles
WHERE category='blah'
ORDER BY datetime DESC
is this what you would save in sql db and then pull data from cassandra? Or can cassandra handle this type of request? (assuming millions of lines in db)
From what I understand, cassandra is great for confusing keyword searches if it can and should be used to get a list of data back and swap that data (and if it is very efficient)
source
share