Hello! As far as my understanding goes, unless you are using 2.7 with its MVCC support, SQL is not transactional and it has no guarantees that your insert + update will work consistently. You could use DataStreamer with allowOverwrite=true to do that in controlled fashion, instead of SQL.
Other than that, if you don't care about consistency that much you could just parallelize your load. Regards, -- Ilya Kasnacheev вт, 30 окт. 2018 г. в 15:03, yangjiajun <1371549...@qq.com>: > Thanks for reply.I need to use merge into statement because my write > operation contains insert and update both.How can I escape this trap? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >