ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "aaron@tophold.com" <aa...@tophold.com>
Subject Re: Re: Did Ignite query support embed DML ?
Date Thu, 20 Jul 2017 02:30:44 GMT
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


id,  total
abc, 0
xyz, 1


id, count
abc, 1
abc, 2
abc, 5
xyz, 3
xyz, 1

Thanks for your time!


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?
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.
View raw message