Re: IF EXISTS checks on all nodes?

2016-05-12 Thread Siddharth Verma
Hi, I missed out on some info node 1,2,3 are in DC1 node 4,5,6 are in DC2 and RF is 3 so all data is on all nodes @Carlos : There was only one query. And yes all nodes have same data for col5 only node 6 has P1,100,A,val1,w1 P1,100,B,val2,w2 P1,200,C,val3,w_x P1,200,D,val4,w4 node 1,2,3,4,5

Re: IF EXISTS checks on all nodes?

2016-05-12 Thread Carlos Rolo
Hello, As far as I know, lightweight transactions only apply to a single partition, so in your case it will only execute on the nodes responsible for that partition. And as a consequence, those nodes will all be in the same state when the transaction ends (If it would apply). Please refer to

IF EXISTS checks on all nodes?

2016-05-12 Thread Siddharth Verma
Hi, If i have inconsistent data on nodes Scenario : I have 2 DCs each with 3 nodes and I have inconsistent data on them node 1,2,3,4,5 have P1,100,A,val1,w1 P1,100,B,val2,w2 node 6 has P1,100,A,val1,w1 P1,100,B,val2,w2 P1,200,C,val3,w3 P1,200,D,val4,w4 col1, col2, col3,col4,col5 in table