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

ashok.dcosta_187920 avatar image
ashok.dcosta_187920 asked ·

Are BATCH statements the preferred way of doing bulk operations in Cassandra?

Are Batch transactions ( Insert update delete) prefered way of doing bulk operation s in cassandra or do we need to rely on ssbload , DSE Bulk Loader , Capture and Copy ?


Thanks

cassandrabatch
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.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

No, definitely not. :) BATCH statements are designed to achieve atomicity when updating multiple tables. Atomic updates are when you need ALL inserts/updates to be applied otherwise NONE should apply.

Unlike relational databases, BATCH statements are not an optimisation -- it can decrease throughput and increase latency if not used properly since it can overload the coordinator nodes making them unresponsive.

I recommend the following documents for more info:

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.