topic Re: TMysqlRow cannot read data from crossengine Tables in Talend Studio

TMysqlRow cannot read data from crossengine Tables

Anonymous — Mon, 24 Sep 2018 11:37:07 GMT

Hi guys,

I'm using Talend7 Java version 8

I got this error when i am trying to perform SQL query from two tables with different engine(MariaDB Column store and INNO DB

It says : (CONN=952) Internal error: CAL0002: Delete Failed: fatal error reading result from cross engine client lib(4294967295)(null pointer)
however ,the query works normal when i am using the other administration tool

Any idea how to fix this?
Thanks

Re: TMysqlRow cannot read data from crossengine Tables

Anonymous — Wed, 26 Sep 2018 07:56:28 GMT

Hello,

What does your sql query look like in tMySqlRow? I haven't see this error before. Could you please give us more information to diagnose your issue?

Best regards

Sabrina

Re: TMysqlRow cannot read data from crossengine Tables

Anonymous — Wed, 26 Sep 2018 09:43:50 GMT

something like

DELETE a FROM main_table a inner join temp_table b on b.PrimKey = a.PrimKey

"
well,i have found the solution,

apparently i just have to put commit at the second line,

thanks