Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Labels (4)
3 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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.