RE: Failed to prepare update plan error while inserting data, when select is used aong with insert

[Alexandr Shapkin]

Hi,   Seems like there is a syntax error and Apache Ignite failed to produce an execution plan   Could you try to run it without the parentheses?   Like: INSERT INTO desttable (name, lastname, age) SELECT name, lastname, age from srctable     From: Alexandr Shapkin Sent: Wednesday, November 18, 2020 5:10 PM To: user@ignite.apache.org Subject: RE: Failed to prepare update plan error while inserting data, when select is used aong with insert   Hi,   Seems like there is a syntax error.         From: harinath Sent: Wednesday, November 18, 2020 10:28 AM To: user@ignite.apache.org Subject: Failed to prepare update plan error while inserting data, when select is used aong with insert   Hi,   Using ignite thick client, i'm trying to copy data from one table into another table using following sql statement   "INSERT INTO desttable (name, lastname, age) (SELECT name, lastname, age from srctable)"   I'm getting the following error while i run sql query. "Failed to prepare update plan."   Not sure of the reason for the error. Any help here will be much appreciated. Thanks in advance   Thanks & Reagrds, Harinath       -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/