Re: SQL support for (insert if not exists, update if exists) operation.

[Mikael]

I guess you have to use UPDATE/INSERT, if the records exists most of the 
time it's not a huge performance killer:

if( update ... == 0)
     insert ....

Mikael

Den 2018-12-05 kl. 11:37, skrev Ilya Kasnacheev:
Hello!

Then answer seems to be "no" then, I guess.

Regards,
--
Ilya Kasnacheev


ср, 5 дек. 2018 г. в 12:49, Ray <ray...@cisco.com 
<mailto:ray...@cisco.com>>:

    Hello Ilya,

    Thanks for the reply.
    I've tried "Merge into", it does not satisfy my needs.

    For example,
    I create a table with
    create table a(a varchar, b varchar,c varchar, primary key(a));

    And I inserted one record into table a with
    merge into a(a,b) values('1','1');

    Then I want to update this record by adding value to column c.
    But when I try this sql

    merge into a(a,c) values('1','1');

    The value of column b is deleted.




    --
    Sent from: http://apache-ignite-users.70518.x6.nabble.com/