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'
Solved! Go to Solution.
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
We will appreciate it a lot if you could post your solution on forum.
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"