My table has some tombstones. The problem is that when I perform a spark job on that table, it gives results without any issue, but if I execute the same query using cqlsh it gives errors because of the tombstones present.
Cassandra failure during read query at consistency one(1 replica needed but o replicas responded ,1 failed
I can reslove the tombstone issue by running a repair, but still, why did spark work and cqlsh fail? Both of them use same session and queries.