When using BATCH on multiple tables you’ll need to use a LOGGED batch. When you send the request, it will be written to the batch log of all (relevant) nodes, when this write is successful it will be “accepted” and nodes will try to apply the batch operations. If for any reason a statement fails the node will keep retrying forever. In that case you may see partially applied batch until it’s fixed.
Note that you can’t mix BATCH and LWT on different tables/partitions. You can get more details here: http://cassandra.apache.org/doc/latest/cql/dml.html#batch https://inoio.de/blog/2016/01/13/cassandra-to-batch-or-not-to-batch/ -- Jacques-Henri Berthemet From: Rajesh Kishore [mailto:rajesh10si...@gmail.com] Sent: Thursday, April 19, 2018 11:13 AM To: user@cassandra.apache.org Subject: Re: Does Cassandra supports ACID txn Thanks for the response. Let me put my question again wrt a example I want to perform a atomic txn say insert/delete/update on a set of tables TableA TableB TableC When these are performed as batch operations and let us say something goes wrong while doing operation at TableC Would the system rollback the operations done for TableA TableB ? -Rajesh On Thu, Apr 19, 2018 at 1:25 PM, Jacques-Henri Berthemet <jacques-henri.berthe...@genesys.com<mailto:jacques-henri.berthe...@genesys.com>> wrote: Cassandra support LWT (Lightweight transactions), you may find this doc interesting: https://docs.datastax.com/en/cassandra/3.0/cassandra/dml/dmlDataConsistencyTOC.html<https://docs.datastax.com/en/cassandra/3.0/cassandra/dml/dmlDataConsistencyTOC.html> In any case, LWT or BATCH you won’t have external control on the tx, it’s either done or not done. In case of timeout you won’t have a way to know if it worked or not. There is no way to rollback a statement/batch, the only way is to send an update to modify the partition to its previous state. Regards, -- Jacques-Henri Berthemet From: DuyHai Doan [mailto:doanduy...@gmail.com<mailto:doanduy...@gmail.com>] Sent: Thursday, April 19, 2018 9:10 AM To: user <user@cassandra.apache.org<mailto:user@cassandra.apache.org>> Subject: Re: Does Cassandra supports ACID txn No ACID transaction any soon in Cassandra On Thu, Apr 19, 2018 at 7:35 AM, Rajesh Kishore <rajesh10si...@gmail.com<mailto:rajesh10si...@gmail.com>> wrote: Hi, I am bit confused by reading different articles, does recent version of Cassandra supports ACID transaction ? I found BATCH command , but not sure if it supports rollback, consider that transaction I am going to perform would be on single partition. Also, what are the limitations if any? Thanks, Rajesh
