Search code examples
mysqltalend

Error in loading data from Talend studio to Mysql

I'm trying to load a CSV data into mysql from talend studio and getting the below mentioned error:

Couldn't parse value for column 'RegisterTime' in 'row1', value is '1974-10-22 08:46:40.000'. Details: java.lang.RuntimeException: Unparseable date: "1974-10-22 08:46:40.000"

Field RegisterTime has the data type as 'Date' and format as yyyy-MM-dd hh:mm:ss.SSS while defining the schema as metadata in the talend studio.

Am I using an incorrect format? Any help in suggesting the right format would be great.

Solution

  • This is probably a Date pattern problem even though the one you indicate is the right one. You should make sure this pattern is used in the component itself by going to the component view -> "Edit Schema".