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, abhi@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
>
|