topic Re: tmySqlInput in Big Data Batch in Talend Studio

tmySqlInput in Big Data Batch

Anonymous — Sat, 16 Nov 2024 07:59:47 GMT

Hi, I am working on Talend Big Data Batch process. Where I need to connect aurora DB and I am using tmySQLInput component as input and my requirement is to join multiple tables as a single query and output the rows. But I am getting error like below and it is working with one single table. Is there any limitation that multiple tables cant be used in one single tmysqlinput. Please let me know

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE 1=0'

Re: tmySqlInput in Big Data Batch

Anonymous — Thu, 05 Jul 2018 21:16:28 GMT

Does tmysqlinput support Join Query?

Re: tmySqlInput in Big Data Batch

Anonymous — Mon, 16 Jul 2018 09:03:44 GMT

Hello,

The tmysqlinput component supports Join Query. What does your custom join query look like? On which talend build version you got this issue?

Here exists a jira issue:https://jira.talendforge.org/browse/TBD-6499

Best regards

Sabrina

Re: tmySqlInput in Big Data Batch

Anonymous — Mon, 16 Jul 2018 16:20:30 GMT

Thanks for your reply. I am able to find the solution to use the query using MysqlInput in Talend job

Re: tmySqlInput in Big Data Batch

Anonymous — Tue, 17 Jul 2018 11:20:03 GMT

Hello,

We will appreciate it a lot if you could post your solution on forum.

Best regards

Sabrina

Re: tmySqlInput in Big Data Batch

Anonymous — Tue, 17 Jul 2018 17:20:55 GMT

sure. When you work on Standard mode you can write the multiple table join query in the "query" layer. But in Big data, you cannot add the join query in "query" mode. So, in tMySQLInput compoenent, in Advanced layer, you have to add the configuration setting like "dbtable" -> "sqlquery"

Re: tmySqlInput in Big Data Batch

Anonymous — Tue, 10 Sep 2019 12:09:27 GMT

can you post screenshot of your tmysqlinput advanced layer with query. I am also facing the same issue with toracleinput component in big data batch.