despite having a strong retry mechanism, what if a batch fails in the mid ? the data which is upserted into the tables will now be inconsistent and as cassandra does not support rollback what will happen in this case ?
Also, all batch operations are atomic right? whether they involve multi partition or single partition that is either the batch is passed or fail . so how consistency is maintained without rollback