Denis Mekhanikov wrote > 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 <
> deepika.singh@ > >: > >> 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/ >> Query i ran over GridGain : UPDATE personalDetails SET personalDetails.age = 26 WHERE EXISTS (SELECT * FROM cityDEtails WHERE cityDEtails.id=personalDetails.F_id AND cityDEtails.pincode = 560102) It ran but didn't update the value ?? . any idea why? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
