Cassandra Possible read/write race condition in LOCAL_ONE?

2019-03-28 Thread Richard Xin
Hi, Our Cassandra Consistency level is currently set to LOCAL_ONE, we have script doing followings 1) insert one record into table_A  2) select last_inserted_record from table_A and do something ... step #1 & 2 are running sequentially without pause,  and I assume 1 & 2 suppose to run in same DC

Re: Cassandra loading data from another table

2018-10-01 Thread Richard Xin
s on Table B if your application is writing on Table A or Table B during this process.Please test first :) Cheers,Christophe Christophe Schmitz - Instaclustr - Cassandra | Kafka | Spark Consulting On Tue, 2 Oct 2018 at 09:18 Richard Xin wrote: I have a tableA with about a few ten millions rec

Cassandra loading data from another table

2018-10-01 Thread Richard Xin
I have a tableA with about a few ten millions record, and I have tableB with a few thousands record,TableA and TableB have exact same schema (except that tableB doesnt have TTL) I want to load all data to tableB from tableA EXCEPT for those already on tableB (we don't want data on tableB to be o