Talend not able to guess schema of a query

Six Stars

Talend not able to guess schema of a query

Hi,

I have connected talend with mssqlserver. I have a query to fetched data from mssqlserver.

When I execute a query on mssqlserver using Toad also directly on mssqlserver.  I am able to see the result while when

while when I use this query on mssqlserver output component(tjdbcinput), it shows a  column does not exist. 

How to deal with this issue. 

Note: I am able to guess schema using other queries. 
talend issue.PNG

 

 

 

 

 

 


Accepted Solutions
Highlighted
Six Stars

Re: Talend not able to guess schema of a query

This query is very long around 500 line. To run the job without guess schema,  I have selected edit schema and created manually the schema. Then I was able to run the job.

 

editschema.PNG


All Replies
Community Manager

Re: Talend not able to guess schema of a query

I can't see your entire query, but I do not see a table either in the query or in the table field. This *could* be connected to the issue. It would be the first thing I would test anyway

Highlighted
Six Stars

Re: Talend not able to guess schema of a query

This query is very long around 500 line. To run the job without guess schema,  I have selected edit schema and created manually the schema. Then I was able to run the job.

 

editschema.PNG

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads