Aaron,
Please show the full exception trace and attach your configuration.
-Val
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Did-Ignite-query-support-embed-DML-tp15120p15973.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Aaron
aa...@tophold.com
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-ig
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 archi
...@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 'WH
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.
hi All,
Will Ignite support Embed SUM DML Like this SQL updates:
UPDATE A a
SET a.total=(
SELECT SUM(b.cnt)
FROM B b
WHERE b.id = a.id
)
Always throw a fail to parse SQL query exception .
aa...@tophold.com
