Re: Batch : Isolation and Atomicity for same partition on multiple table

2017-12-15 Thread Mickael Delanoë
Yes, we try to rely on conditional batches when possible but in this case it could not be used : We did some tests with the conditional batches and they could not be applied when several tables are involved in the batch, even if the tables use the same partition key : we had the following error "ba

Re: Batch : Isolation and Atomicity for same partition on multiple table

2017-12-14 Thread Jeff Jirsa
Again, a lot of potential problems can be solved with data modeling - in particular consider things like conditional batches where the condition is on a static cell/column and writes go to different CQL rows. -- Jeff Jirsa > On Dec 14, 2017, at 9:57 PM, Mickael Delanoë wrote: > > Thanks Je

Re: Batch : Isolation and Atomicity for same partition on multiple table

2017-12-14 Thread Mickael Delanoë
Thanks Jeff, I am a little disappointed when you said the guarantee are even weeker.But I will take a look on this and try to understand what is really done. Le 13 déc. 2017 18:18, "Jeff Jirsa" a écrit : Entry point is here: https://github.com/apache/cassandra/blob/trunk/ src/java/org/apache/c

Re: Batch : Isolation and Atomicity for same partition on multiple table

2017-12-13 Thread Jeff Jirsa
Entry point is here: https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/cql3/statements/BatchStatement.java#L346 , which will call through to https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/service/StorageProxy.java#L938-L953 I believe the gua

Re: Batch : Isolation and Atomicity for same partition on multiple table

2017-12-13 Thread Mickael Delanoë
Hi Nicolas, Thanks for you answer. Is your assumption 100% sure ? Because the few test I did - using nodetools getendpoints - shown that the data for the two tables when I used the same partition key went to the same "nodes" . So I would have expected cassandra to be smart enough to apply them in t

Re: Batch : Isolation and Atomicity for same partition on multiple table

2017-12-13 Thread Nicolas Guyomar
Hi Mickael, Partition are related to the table they exist in, so in your case, you are targeting 2 partitions in 2 different tables. Therefore, IMHO, you will only get atomicity using your batch statement On 11 December 2017 at 15:59, Mickael Delanoë wrote: > Hello, > > I have a question regard

Batch : Isolation and Atomicity for same partition on multiple table

2017-12-11 Thread Mickael Delanoë
Hello, I have a question regarding batch isolation and atomicity with query using a same partition key. The Datastax documentation says about the batches : "Combines multiple DML statements to achieve atomicity and isolation when targeting a single partition or only atomicity when targeting multi