Iím a little old fashioned and say if there is a query you do as part of a hot code path it should be supported by materialising a view at write time rather than using secondary indexes. That will give you better performance.
As I understand it, where clauses only apply to primary keys and secondary indices.
Note that when using CQL 3 you donít have to specify all of the primary key, just the partition key and then parts of the cluster key.
From what I've researched it appears two options are to use solr or elasticsearch.
If you want the equivalent of being able to put any term in the CQL WHERE clause then yes those are two options.
Or you can use the Hadoop integration if you want to process all of your data.
Co-Founder & Principal Consultant
Apache Cassandra Consulting
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.