Re: Re: Did Ignite query support embed DML ?
If you just calculate the sum, then you don't need to join, right? Just remove the WHERE clause. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Did-Ignite-query-support-embed-DML-tp15120p15198.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Re: Did Ignite query support embed DML ?
Thanks Val, This A is the parent table, B is children table, we want to SUM the value in B table and set back to the A. they join by the id, possible data like this A: id, total abc, 0 xyz, 1 B: id, count abc, 1 abc, 2 abc, 5 xyz, 3 xyz, 1 Thanks for your time! Regards Aaron aa...@tophold.com From: vkulichenko Date: 2017-07-20 06:10 To: user Subject: Re: Did Ignite query support embed DML ? You don't have table A in the subquery, I guess that's the reason for the failure. What exactly are you trying to achieve with this query? What is the purpose of 'WHERE b.id = a.id' clause? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Did-Ignite-query-support-embed-DML-tp15120p15146.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Did Ignite query support embed DML ?
You don't have table A in the subquery, I guess that's the reason for the failure. What exactly are you trying to achieve with this query? What is the purpose of 'WHERE b.id = a.id' clause? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Did-Ignite-query-support-embed-DML-tp15120p15146.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
