Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

mishra.anurag643_153409 avatar image
mishra.anurag643_153409 asked Erick Ramirez answered

What are the limitations or restrictions with CQL BATCH?

I am looking for summary on cassandra batch . I am aware that in multi partition batch lightweight transactions can not be applied . In similar way what are other cases when batch operation might be failed ?

batch
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Artem Chebotko avatar image
Artem Chebotko answered

Batch use cases and limitations are described in this scenario.

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Erick Ramirez avatar image
Erick Ramirez answered

The only time a CQL BATCH fails is when the coordinator does not get an acknowledgement that the write to the batch log is successful on 2 randomly picked nodes. In this case, the statements in the BATCH do not get applied and a failed exception is returned to the client.

In the case where a conditional statement is included in the BATCH, the entire batch does not get applied if the conditional statement does not equate to true. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.