Re: Writing to multiple tables

2015-03-16 Thread DuyHai Doan
"Is BATCH the recommended way of updating all three tables at one go so that the information between the three tables is consistent ? " If you're thinking about "atomicity", no it's not atomic. Indeed with logged batches, what you gain is automatic retry done for you by the coordinator in case of

Re: Writing to multiple tables

2015-03-16 Thread Robert Coli
On Mon, Mar 16, 2015 at 12:13 PM, Viswanathan Ramachandran < vish.ramachand...@gmail.com> wrote: > Is BATCH the recommended way of updating all three tables at one go so > that the information between the three tables is consistent ? > As a general statement : If you are looking to update multip

Writing to multiple tables

2015-03-16 Thread Viswanathan Ramachandran
Hi, Are Cassandra Batch statements http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/batch_r.html the recommended way for updating same information in multiple tables? For example if I have the following tables: person_by_dob person_by_ssn person_by_lastname Then addition/modifi