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

classic Classic list List threaded Threaded
6 messages Options
harinath harinath
Reply | Threaded
Open this post in threaded view
|

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/
Alexandr Shapkin Alexandr Shapkin
Reply | Threaded
Open this post in threaded view
|

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: [hidden email]
Sent: Wednesday, November 18, 2020 10:28 AM
To: [hidden email]
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/

 

Alex Shapkin
Alexandr Shapkin Alexandr Shapkin
Reply | Threaded
Open this post in threaded view
|

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 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: [hidden email]
Sent: Wednesday, November 18, 2020 5:10 PM
To: [hidden email]
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: [hidden email]
Sent: Wednesday, November 18, 2020 10:28 AM
To: [hidden email]
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/

 

 

Alex Shapkin
harinath harinath
Reply | Threaded
Open this post in threaded view
|

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

Hi Alexandar,

I have tried without parentheses, still i see the same error

Thanks,
Harinath



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Alexandr Shapkin Alexandr Shapkin
Reply | Threaded
Open this post in threaded view
|

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

Hi,

 

That’s odd, could you please share the logs with  the error?

 

 

 

From: [hidden email]
Sent: Wednesday, November 18, 2020 6:52 PM
To: [hidden email]
Subject: RE: Failed to prepare update plan error while inserting data, when select is used aong with insert

 

Hi Alexandar,

 

I have tried without parentheses, still i see the same error

 

Thanks,

Harinath

 

 

 

--

Sent from: http://apache-ignite-users.70518.x6.nabble.com/

 

Alex Shapkin
harinath harinath
Reply | Threaded
Open this post in threaded view
|

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

Hi Alexandar,

Sorry my bad. I just realized that the primary key is missed while
inserting.

Thanks for your response and help

Thanks.
Harinath



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/