Re: INSERT query that UPDATES if record already found

Sounds like you're looking for the MERGE command: https://apacheignite-sql.readme.io/docs/merge -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

INSERT query that UPDATES if record already found

Hi There, I'm using Ignite 2.4 with JDBC mainly as an in mem Cache and looking for a way to write the fastest query to insert new record but if a record with the same key already exists I would like it to be updated. DDL looks like this: CREATE TABLE PERSON ( Id VARCHAR, name VARCHAR, PRIMAR