Thanks Val, I need the SUM result set back to the table A.
I try MERGE INTO; but seem Ignite not work like standard SQL. Even I use MERGE I have to include all other column if any present in table A. like below table. MERGE INTO A (_key, total) ( SELECT b.id, SUM(b.count), FROM cacheB.B b GROUP BY ap.accountId ) It always throw exception the A'a anotherColumn should not be NULL. Thanks for your time! Regards Aaron ----------------------- A: id, total, anotherColumn abc, , 0, 12345 xyz, 1, 6789 B: id, count abc, 1 abc, 2 abc, 5 xyz, 3 xyz, 1 Regards Aaron [email protected] From: vkulichenko Date: 2017-07-21 02:44 To: user Subject: 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.
