Hello! Apache Ignite has MERGE INTO https://apacheignite-sql.readme.io/docs/merge but I've heard that it's not very efficient.
Regards, -- Ilya Kasnacheev ср, 5 дек. 2018 г. в 12:27, Ray <[email protected]>: > I want to know if it's possible to do "replace into" like Mysql in Ignite. > Because currently I have these following code to implement this (insert if > not exists, update if exists) logic. > if not exists (select 1 from t where id = 1) > insert into t(id, update_time) values(1, getdate()) > else > update t set update_time = getdate() where id = 1 > > In mysql, I can use this one liner sql to do the job. > > replace into t(id, update_time) values(1, now()); > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
