Thanks Evgenii, We will check further.
Regards Aaron Aaron.Kuai From: ezhuravlev Date: 2018-03-22 01:41 To: user Subject: Re: Did update SQL support joiner? Hi, First of all, you need to check that all data is collocated since by default join will be performed on each node on the collocated data. Also, I don't see FROM in UPDATE grammar in H2: http://www.h2database.com/html/grammar.html#update So, I would recommend to rewrite it using subquery. Regards, Evgenii -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/