You can apply this query really simply using cassandra and secondary
indexes.
You will have a CF "TABLE", where row keys are your PK. Just to be sure
of my understanding, your SQL query will either return 1 row or no row,
right ?
3) SliceQuery returns a range of columns for a given key, it may be your
friend.
On 11. 08. 11 07:50, a...@9y.com wrote:
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