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
1) Is it possible to design to get equivalent results for above
query ( using CQL or Hector) with Cassandra.
If this is a common query in your app it's god idea to design the data model to
support the request. Seems safe to assume the PK in your example is non
unique, I'll call it the FKID
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
