I have a requirement to get certain counts from my table, in cassandra. What I understood is its not a good idea to run count queries in cassandra as it scans all the nodes. We already have solr indexes enabled for few tables in cassandra, and I was trying to use this feature to run my count queries. After looking on the web, found this article https://www.datastax.com/blog/running-count-expensive-cassandra, which also mentions Solr a possible solution to perform count queries.
Is it ok to run count using solr indexes on my cassandra table. Something like this
select count(1) from employee where solr_query='{"q": "employee_department:HR"}' // just a random example