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 have P1,100,A,val1,w1 P1,100,B,val2,w2 P1,200,C,null,w_x So, when "consistency all" in cqlsh 1.IF EXISTS is checked ON EVERY NODE before applying, and if it is true on all, ONLY then it is applied OR 2. IF EXISTS was true on one, so applied on all.
