tmySqlInput in Big Data Batch

Six Stars

tmySqlInput in Big Data Batch

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'


Accepted Solutions
Six Stars

Re: tmySqlInput in Big Data Batch

Does tmysqlinput support Join Query?

View solution in original post


All Replies
Six Stars

Re: tmySqlInput in Big Data Batch

Does tmysqlinput support Join Query?

View solution in original post

Moderator

Re: tmySqlInput in Big Data Batch

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: tmySqlInput in Big Data Batch

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

Moderator

Re: tmySqlInput in Big Data Batch

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: tmySqlInput in Big Data Batch

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"

Four Stars

Re: tmySqlInput in Big Data Batch

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now