cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Lin <>
Subject Are indexes replicated to all nodes?
Date Mon, 24 Feb 2014 15:20:07 GMT
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

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?



View raw message