I have added bulk data , i am able to get count of rows but when i am executing select statement i am getting ReadFailure: Error from server: code=1300 [Replica(s) failed to execute read] message="Operation failed - received 0 responses and 1 failures" info={'failures': 1, 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
when checking logs i found the warn message Scanned over 100001 tombstones during query 'SELECT * FROM test_keyspace.employee WHERE roll_no= 2200 AND () = () LIMIT 100' (last scanned row partion key was (25281)); query aborted
I have ran compaction still getting this much tombstone i have inserted null values i think this is reason of this what could be the best practice to avoid this .
