I have use case which requires choosing either Stratio cassandra-lucene-index or Elastic Search on Cassandra. I am more aligned towards the Stratio implementation as it doesn't require creating/managing ES clusters. However, the below scenario puts the solution implementation in difficult situation.
Cassandra lucene Index is created on high cardinality column e.g. colA in a key space Test (Keyspace has more than 10,000 unique records for colA) and following query is executed using Cassandra-lucene-index.
select * from Test where colA like “1%”
Now, the above query will require hitting all the nodes in the Cassandra cluster as the Cassandra Lucene indexes are local indexes.
So, Will the query performance in such a scenario scale well with Cassandra-lucene-index compared to results returned from ElasticSearch Cluster with data feed from Cassandra as data in the Keyspace increases?
Tools version: Cassandra 3.10, Stratio cassandra-lucene-index 3.10