I've recently started with Cassandra I'm curious about how data can be searched. As I understand it, where clauses only apply to primary keys and secondary indices.

From what I've researched it appears two options are to use solr or elasticsearch. I'd appreciate feeback from those that have used either of the tools as to the challenges of integrating with Cassandra. I'd also appreciate insight on what other tools/methods are available. Thanks.