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