topic Re: MySqlInput - Guess Schema - CSV not found Error in Talend Studio

MySqlInput - Guess Schema - CSV not found Error

Anonymous — Sat, 16 Nov 2024 09:28:21 GMT

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

Re: MySqlInput - Guess Schema - CSV not found Error

Anonymous — Tue, 01 Aug 2017 04:13:54 GMT

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

Re: MySqlInput - Guess Schema - CSV not found Error

Anonymous — Tue, 01 Aug 2017 09:55:20 GMT

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.

Re: MySqlInput - Guess Schema - CSV not found Error

Anonymous — Mon, 07 Oct 2019 11:48:08 GMT

I am experiencing this issue and was wondering if you ever found a solution. Thank you so much! I've tried both manually creating it and also from a saved query. When I go look there is no temp folder in my talend directory. I'm wondering if its a permissions issue on my drive and the application is not able to write to the folder.