I was looking at the indexing code in Cassandra server and couldn't determine if the indexes use the same replication factor as the keyspace. When I print out the details of the keyspace, it correctly show the replication factor, which "suggests" the index for a given partition only lives on the same node.
I ask for a couple of reasons. Sometimes, users may want to be able to run queries like these. select * from MyColumnFamily where Column1='some1' or Column4='other1' select * from MyColumnFamily where Column2 like '%OOP%' and Column5 like '%architect%' In our tooling, we've integrated Solr, so that we can do queries like this with our query API. The query API looks like JPA/Hibernate, so we off load the work to Solr when needed. If the indexes were replicated to all nodes (aka partitions), Cassandra server could then use index joins and return the results to the client. The client can then merge the results. What we do now is we query Solr to get the list of keys and then query cassandra for the records by key. anyone know the answer off hand? thanks peter
