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
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
Are BATCH statements the preferred way of doing bulk operations in Cassandra?
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!
6 People are following this question.
