Is it a single query? Why not execute these two updates separately?
I don't see any problems in the first one.
The second one needs some refactoring though.
Ignite uses an SQL query engine of H2, which doesn't support JOINs in
UPDATE statements.
But you may change it in the following way:
UPDATE table1 SET table1.quantity = 6 WHERE EXISTS
(SELECT * FROM table2 WHERE table2.pid=table1.pid AND table2.zip ='abc')
;
Denis
чт, 27 дек. 2018 г. в 12:49, DS <[email protected]>:
> I am looking solution for queries like below :
>
> Update Person SET lastName ='pit' where person.id =city.id AND
> city.zipCode
> ='B8Q97'
>
> OR
>
> UPDATE table1, table2 SET table1.quantity = 6 where table1.pid =table2.pid
> AND table2.zip ="abc"
>
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
