You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by "swaroopchenchu (via GitHub)" <gi...@apache.org> on 2025/06/11 05:34:33 UTC
[D] How to convert String to timestamp datatype (hop)
GitHub user swaroopchenchu created a discussion: How to convert String to timestamp datatype
I am using select values transform convert the string eg: yyyy-MM-dd HH:mm:ss.SSS to timestamp datatype in postgres.
But failing with error
2025/06/10 16:38:16 - CaseManagement-Direct-DB - Caused by: com.fasterxml.jackson.databind.JsonMappingException: **CreatedOn String(50) : There was a data type error: the data type of java.sql.Timestamp object [2017-12-05 10:32:42.0] does not correspond to value meta [String(50)] (through reference chain: org.apache.hop.execution.ExecutionData["rowsBinaryGzipBase64Encoded"])**
2025/06/10 16:38:16 - CaseManagement-Direct-DB - at
> com.fasterxml.jackson.databind.JsonMappingException.wrapWithPath(JsonMappingException.java:402)
2025/06/10 16:38:16 - CaseManagement-Direct-DB - at com.fasterxml.jackson.databind.JsonMappingException.wrapWithPath(JsonMappingException.java:361)
2025/06/10 16:38:16 - CaseManagement-Direct-DB - at com.fasterxml.jackson.databind.ser.std.StdSerializer.wrapAndThrow(StdSerializer.java:323)
<?xml version="1.0" encoding="UTF-8"?>
<pipeline-transforms>
<transforms>
<transform>
<name>Fix Data Types</name>
<type>SelectValues</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<fields>
<meta>
<conversion_mask>yyyy-MM-dd HH:mm:ss.SSS</conversion_mask>
<currency_symbol/>
<date_format_lenient>N</date_format_lenient>
<date_format_locale/>
<date_format_timezone>UTC</date_format_timezone>
<decimal_symbol/>
<encoding/>
<grouping_symbol/>
<length>-2</length>
<lenient_string_to_number>N</lenient_string_to_number>
<name>CreatedOn</name>
<precision>-2</precision>
<rename>CreatedOn</rename>
<storage_type/>
<type>Timestamp</type>
</meta>
<meta>
<conversion_mask>yyyy-MM-dd HH:mm:ss.SSS</conversion_mask>
<currency_symbol/>
<date_format_lenient>N</date_format_lenient>
<date_format_locale/>
<date_format_timezone>UTC</date_format_timezone>
<decimal_symbol/>
<encoding/>
<grouping_symbol/>
<length>-2</length>
<lenient_string_to_number>N</lenient_string_to_number>
<name>ModifiedOn</name>
<precision>-2</precision>
<rename>ModifiedOn</rename>
<storage_type/>
<type>Timestamp</type>
</meta>
<meta>
<conversion_mask>yyyy-MM-dd HH:mm:ss.SSS</conversion_mask>
<currency_symbol/>
<date_format_lenient>N</date_format_lenient>
<date_format_locale/>
<date_format_timezone>UTC</date_format_timezone>
<decimal_symbol/>
<encoding/>
<grouping_symbol/>
<length>-2</length>
<lenient_string_to_number>N</lenient_string_to_number>
<name>rkn_ETR</name>
<precision>-2</precision>
<rename>rkn_ETR</rename>
<storage_type/>
<type>Timestamp</type>
</meta>
<select_unspecified>N</select_unspecified>
</fields>
<attributes></attributes>
<GUI>
<xloc>736</xloc>
<yloc>432</yloc>
</GUI>
</transform>
</transforms>
<order>
</order>
<notepads>
</notepads>
<transform_error_handling>
</transform_error_handling>
</pipeline-transforms>
Anyone please help me on this.
Thanks
GitHub link: https://github.com/apache/hop/discussions/5407
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] How to convert String to timestamp datatype (hop)
Posted by "hansva (via GitHub)" <gi...@apache.org>.
GitHub user hansva added a comment to the discussion: How to convert String to timestamp datatype
Is your pipeline actually failing?
it seems the error is coming from the execution information location and that is a known bug https://github.com/apache/hop/issues/2312
GitHub link: https://github.com/apache/hop/discussions/5407#discussioncomment-13429014
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org
Re: [D] How to convert String to timestamp datatype (hop)
Posted by "swaroopchenchu (via GitHub)" <gi...@apache.org>.
GitHub user swaroopchenchu added a comment to the discussion: How to convert String to timestamp datatype
@hansva you were right, its was working
Thanks
GitHub link: https://github.com/apache/hop/discussions/5407#discussioncomment-13754443
----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org