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: 
talendstar
Creator
Creator

java.lang.NumberFormatException: For input string: "08:30:00"

I am trying to load a table from SQL Server to Snowflake.

The data type in SQL Server is Time.

 

Here is what the tmap looks like:

0683p000009M8rK.png

 

Here is the schema editor in tmap:

0683p000009M8rP.png

 

Originally I created the SF table with these columns setup as Time data type but that didn't work (I would like to keep the destination data type time).

However since I couldn't get that to work I changed the data type in Snowflake(SF) to varchar hoping TalendDate.formatDate can take the incoming time as output it as a string but not having much luck there either.

 

Here is the error that I get:

Exception in component tDBOutput_1 (DAILYTOURSLOTS)
java.lang.NumberFormatException: For input string: "08:30:00"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.valueOf(Unknown Source)
at org.talend.codegen.enforcer.IncomingSchemaEnforcer.put(IncomingSchemaEnforcer.java:507)
at org.talend.codegen.enforcer.IncomingSchemaEnforcer.put(IncomingSchemaEnforcer.java:379)
at avbtalend71.dailytourslots_0_1.DAILYTOURSLOTS.tDBInput_1Process(DAILYTOURSLOTS.java:1734)
at avbtalend71.dailytourslots_0_1.DAILYTOURSLOTS.runJobInTOS(DAILYTOURSLOTS.java:2281)
at avbtalend71.dailytourslots_0_1.DAILYTOURSLOTS.main(DAILYTOURSLOTS.java:2107)

 

 

Here is what the source data for these columns looks like:

0683p000009M8hV.png

 

Any thoughts on how to process the time (field only contains time and does not have any date on it).

 

thanks

Labels (4)
3 Replies
vapukov
Master II
Master II

Hi,

 

you must to check settings in the output component tDBOutput_1

possible in tMap you have defined columns as a String, but in database output component as Integer

talendstar
Creator
Creator
Author

I have verified the Snowflake table. Colunms are defined as varchar in Snowflake table.

 

 

vapukov
Master II
Master II

just to be 100% correct - did you check it in Studio component schema? (or in database?)

you need to check in tSnowFlakeOutput component, you can share the picture as well

 

 

cheers,