Batches don't work like that. It's possible for some to succeed, and
later, the rest will. Atomic is the incorrect word to use, it's more like
"eventually they will all go through".
Do not use IN(), use a whole bunch of prepared statements asynchronously.
On Wed, Jun 10, 2015 at 9:26 AM Sotirios Delimanolis <sotodel...@yahoo.com>
wrote:
> Hi,
>
> When executing a DELETE statement with an IN clause, where the list
> contains partition keys, what is the underlying behaviour with regards to
> atomicity?
>
> DELETE FROM MastersOfTheUniverse WHERE mastersID IN ('Man-At-Arms', 'Teela');
>
>
> Is it going to act like an atomic batch where if one fails, all fail? If
> that is the case, is there any reason to use a BATCH statement with
> multiple single DELETE statement or should we always prefer a DELETE with
> an IN clause?
>
> For example, given 3000 keys for rows I want to delete, should I issue a
> single DELETE query and provide all the keys in the IN argument or should
> I add 3000 DELETE queries to a BATCH statement?
>
> Thank you,
> Sotirios
>
>
>
