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

2017-12-15 Thread Mickael Delanoë
ons 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 regarding batch isolation and a

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

2017-12-14 Thread Jeff Jirsa
el, >>> >>> 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 Decembe

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

2017-12-14 Thread Mickael Delanoë
will only get atomicity using your batch statement >> >> On 11 December 2017 at 15:59, Mickael Delanoë >> wrote: >> >>> Hello, >>> >>> I have a question regarding batch isolation and atomicity with query >>> using a same partition key. >&g

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

2017-12-13 Thread Jeff Jirsa
geting 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 regarding batch

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

2017-12-13 Thread Mickael Delanoë
2017 at 15:59, Mickael Delanoë > wrote: > >> 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 statem

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

2017-12-13 Thread Nicolas Guyomar
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 targe

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 Martin Krasser
2 *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 (= all rows share the same partition key) using a BATCH statement. Is it possible that other clients can partially read that batch or

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 > wrote: If RF > 1, the consistency level at QUORUM cannot guarantee strict isolation (for normal mutation or batch). If you look at this slide: http://www.slid

Re: Batch isolation within a single partition

2015-05-19 Thread Stefan Podkowinski
isolation> guarantees 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 wit

Re: Batch isolation within a single partition

2015-05-19 Thread Sylvain Lebresne
On Tue, May 19, 2015 at 9:42 AM, DuyHai Doan wrote: > If RF > 1, the consistency level at QUORUM cannot guarantee strict > isolation (for normal mutation or batch). If you look at this slide: > http://www.slideshare.net/doanduyhai/cassandra-introduction-apache-con-2014-budapest/25, > you can see

Re: Batch isolation within a single partition

2015-05-19 Thread DuyHai Doan
ml#batchStmt> docs at >> cassandra.apache.org mention that *"* *... the [batch] operations are >> still only isolated within a single partition"* which is a clear >> statement but doesn't it contradict the previous and the next one? >> >> - The CQL BATC

Re: Batch isolation within a single partition

2015-05-18 Thread Martin Krasser
single partition"/ which is a clear 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

Re: Batch isolation within a single partition

2015-05-18 Thread DuyHai Doan
t 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 mention that *"... there is no batch isolation. > Clients are able to read the first updat

Batch isolation within a single partition

2015-05-18 Thread Martin Krasser
ence/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: cli

Re: batch isolation

2012-06-11 Thread aaron morton
>> (that stands for insert in the batch itself). >> >> -- >> Sylvain >> >> >>> >>> >>> -Original Message- >>> From: Sylvain Lebresne [sylv...@datastax.com] >>> Received: Sunday, 03 Jun 2012, 3:44am >>&g

Re: batch isolation

2012-06-04 Thread Todd Burruss
ll 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@cass

Re: batch isolation

2012-06-04 Thread Sylvain Lebresne
one 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: R

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 isolation

2012-06-03 Thread Sylvain Lebresne
On Sun, Jun 3, 2012 at 2:53 AM, Todd Burruss 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 ...", since a b

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 isol