I'm reading the OP as doing this from a single server, if that's the case QUORUM / LOCAL_QUORUM will work.
On Thu, Mar 28, 2019 at 3:29 PM Jeff Jirsa <[email protected]> wrote: > > Yes it can race; if you don't want to race, you'd want to use SERIAL or > LOCAL_SERIAL. > > On Thu, Mar 28, 2019 at 3:04 PM Richard Xin <[email protected]> > wrote: >> >> 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 >> >> we are facing sporadic issues that step #2 didnt get inserted data by #1. >> is it possible to have a race condition when LOCAL_ONE that #2 might not get >> inserted data on step #1? >> >> Thanks in advance! >> Richard --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
