I recently started with Cassandra and found interesting. I was curious in SQL we have
SELECT * from TABLE where PK="primary_key" and other_attribute between 500 and 1000; My questions are : 1) Is it possible to design to get equivalent results for above query ( using CQL or Hector) with Cassandra. 2) How can we design CF in that case? Using secondary index is an option but I am not clear how that can be applied here. 3) Is there any way we can have a range slice over columns names instead of having range or row keys. I am just a novice. So, Can anyone help me with these question