Four Stars

MySqlInput - Guess Schema - CSV not found Error

Hello talend community,

 

in MysqlInput always when I want to load the schema from a MySQL table by clicking on 'Guess schema' I get get this error message:

 

Connection Error
java.io.FileNotFountException: PATH_TO_TALEND/temp/TempGuessSchemaDelimitedFile.csv.

 

Why does talend needs a csv file? I just want to load the schema.

 

System config:
OS: Win7 64bit
Java: jre-8u144-win-i586
Talend: 6.4.1.20170623_1246

 

Thanks in advanced

2 REPLIES
Community Manager

Re: MySqlInput - Guess Schema - CSV not found Error

Hi
Have you defined the query? The guess schema functions based on the query you defined.
If you want to retrieve the table schema, you should define a db connection under Metadata in repository and retrieve the table schema, afterwards, select the schema from repository on tMysqlInput.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: MySqlInput - Guess Schema - CSV not found Error

Hi Shong,

 

yes, I defined the query "Select * From first". I have defined a db connection under Metadata in repository. I also have determined the schema for this db connection. I still get this error. The weird thing is that it is looking for an csv file.