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

2017-12-15 Thread Mickael Delanoë
t; 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 Delan

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

2017-12-14 Thread Jeff Jirsa
gt; >> 2017-12-13 11:18 GMT+01:00 Nicolas Guyomar <nicolas.guyo...@gmail.com>: >>> 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, IM

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

2017-12-14 Thread Mickael Delanoë
argeting 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ë <delanoe...@gmail.com> >> wrote: >> >>> Hello, >>> >>> I hav

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

2017-12-13 Thread Jeff Jirsa
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ë <delanoe...@gmail.com> >> wrote: >> &

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

2017-12-13 Thread Mickael Delanoë
atement > > On 11 December 2017 at 15:59, Mickael Delanoë <delanoe...@gmail.com> > wrote: > >> Hello, >> >> I have a question regarding batch isolation and atomicity with query >> using a same partition key. >> >> The Datastax documentati

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

2017-12-13 Thread Nicolas Guyomar
lo, > > 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 partiti

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 targ

Re: Batch isolation within a single partition

2015-05-19 Thread Sylvain Lebresne
On Tue, May 19, 2015 at 9:42 AM, DuyHai Doan doanduy...@gmail.com wrote: If RF 1, the consistency level at QUORUM cannot guarantee strict isolation (for normal mutation or batch). If you look at this slide:

Re: Batch isolation within a single partition

2015-05-19 Thread DuyHai Doan
/cql_reference/batch_r.html docs at docs.datastax.com mention that *... there is no batch isolation. Clients are able to read the first updated rows from the batch, while other rows are still being updated on the server. However, transactional row updates within a partition key are isolated

Re: Batch isolation within a single partition

2015-05-19 Thread Martin Krasser
On 19.05.15 10:04, Sylvain Lebresne wrote: On Tue, May 19, 2015 at 9:42 AM, DuyHai Doan doanduy...@gmail.com mailto:doanduy...@gmail.com wrote: If RF 1, the consistency level at QUORUM cannot guarantee strict isolation (for normal mutation or batch). If you look at this slide:

Re: Batch isolation within a single partition

2015-05-19 Thread Stefan Podkowinski
as any single write operation on that key. Von: Martin Krasser [mailto:krass...@googlemail.com] Gesendet: Montag, 18. Mai 2015 12:32 An: user@cassandra.apache.org Betreff: Batch isolation within a single partition Hello, I have an application that inserts multiple rows within a single partition

Re: Batch isolation within a single partition

2015-05-19 Thread Martin Krasser
@cassandra.apache.org *Betreff:* Batch isolation within a single partition Hello, I have an application that inserts multiple rows within a single partition (= all rows share the same partition key) using a BATCH statement. Is it possible that other clients can partially read that batch or is the batch application

Re: Batch isolation within a single partition

2015-05-18 Thread DuyHai Doan
/cql/cql_reference/batch_r.html docs at docs.datastax.com mention that *... there is no batch isolation. Clients are able to read the first updated rows from the batch, while other rows are still being updated on the server. However, transactional row updates within a partition key are isolated

Re: Batch isolation within a single partition

2015-05-18 Thread Martin Krasser
statement but doesn't it contradict the previous and the next one? - The CQL BATCH http://docs.datastax.com/en/cql/3.1/cql/cql_reference/batch_r.html docs at docs.datastax.com http://docs.datastax.com mention that /... there is no batch isolation. Clients are able to read

Batch isolation within a single partition

2015-05-18 Thread Martin Krasser
that /... there is no batch isolation. Clients are able to read the first updated rows from the batch, while other rows are still being updated on the server. However, transactional row updates within a partition key are isolated: clients cannot read a partial update/. Also, what does /transactional

Re: batch isolation

2012-06-11 Thread aaron morton
: Sylvain Lebresne [sylv...@datastax.com] Received: Sunday, 03 Jun 2012, 3:44am To: user@cassandra.apache.org [user@cassandra.apache.org] Subject: Re: batch isolation On Sun, Jun 3, 2012 at 2:53 AM, Todd Burruss bburr...@expedia.com wrote: 1 ­ does this mean that a batch_mutate that first sends

Re: batch isolation

2012-06-04 Thread Sylvain Lebresne
timestamp will be deleted (that stands for insert in the batch itself). -- Sylvain -Original Message- From: Sylvain Lebresne [sylv...@datastax.com] Received: Sunday, 03 Jun 2012, 3:44am To: user@cassandra.apache.org [user@cassandra.apache.org] Subject: Re: batch isolation On Sun, Jun 3

Re: batch isolation

2012-06-04 Thread Todd Burruss
itself). -- Sylvain -Original Message- From: Sylvain Lebresne [sylv...@datastax.com] Received: Sunday, 03 Jun 2012, 3:44am To: user@cassandra.apache.org [user@cassandra.apache.org] Subject: Re: batch isolation On Sun, Jun 3, 2012 at 2:53 AM, Todd Burruss bburr...@expedia.com wrote

Re: batch isolation

2012-06-03 Thread Sylvain Lebresne
On Sun, Jun 3, 2012 at 2:53 AM, Todd Burruss bburr...@expedia.com wrote: 1 – does this mean that a batch_mutate that first sends a row delete mutation on key X, then subsequent insert mutations for key X is isolated? I'm not sure what you mean by having a batch_mutate that first sends ... then

Re: batch isolation

2012-06-03 Thread Todd Burruss
I just meant there is a row delete in the same batch as inserts - all to the same column family and key -Original Message- From: Sylvain Lebresne [sylv...@datastax.com] Received: Sunday, 03 Jun 2012, 3:44am To: user@cassandra.apache.org [user@cassandra.apache.org] Subject: Re: batch

batch isolation

2012-06-02 Thread Todd Burruss
reading the 1.1 what's new here, http://www.datastax.com/docs/1.1/getting_started/new_features, I'm wondering about row level isolation. two questions: 1 – does this mean that a batch_mutate that first sends a row delete mutation on key X, then subsequent insert mutations for key X is