In one of our LCS table auto compaction was disabled. Now after years of run, range queries using spark-cassandra-connector are failing. Cassandra version is 2.1.16.
I suspect due to disabling of autocompaction lots of tombstones got created. And now while reading those are creating issues and queries are getting timed out. Am I right in my thinking? What is the possible way to get out of this? I thought of using major compaction but for LCS that was introduced in Cassandra 2.2. Also user defined compactions dont work on LCS tables. Regards Manish Khandelwal