Index and schema review

2012-02-08 Thread Tiwari, Dushyant
Hi Cassandra Users, I am considering Cassandra as the main data store. Just a quick description of the entity structure that we are looking at to store/design schema for. So we have 3 entities A,B and C. A has one to many relationship with B and similar is true for B and C. Hence this gives us

Re: Index and schema review

2012-02-08 Thread aaron morton
1. Are the indexes local? i.e if node 1 holds say 10 keys that will only have indexes for theses 10 keys. In short – interested in knowing how is the index partitioned? Yes, nodes only hold the secondary indexes for the rows they are a replica for. This means it's token range and the