'Timestamp without timezone' DB type does not work with tRedshiftInput Schema in Talend Studio 7.1.1

BI1 — Mon, 18 Feb 2019 12:36:44 GMT

Hi,

In tRedshiftInput , I want to read data of Timestamp type in Database (yyyy-mm-dd HH:mm:ss) . When I put the data type as Timestamp without timezone and give format as "yyyy-MM-dd HH:mm:ss" , it gives error :-

[Amazon][JDBC](10140) Error converting value to Timestamp.
at com.amazon.exceptions.ExceptionConverter.toSQLException(Unknown Source)
at com.amazon.utilities.conversion.TypeConverter.convertToTimestamp(Unknown Source)
at com.amazon.utilities.conversion.TypeConverter.toTimestamp(Unknown Source)
at com.amazon.jdbc.common.SForwardResultSet.getTimestamp(Unknown Source)
at routines.system.JDBCUtil.getDate(JDBCUtil.java:61) ....

The same operation and query worked well when the job was complied and built in T6.5 Version . Can you please help?

Re: 'Timestamp without timezone' DB type does not work with tRedshiftInput Schema in Talend Studio 7.1.1

akumar2301 — Mon, 18 Feb 2019 13:01:22 GMT

workaround :
if nothing works out , convert your timestand col to Char and read it in Talend

https://docs.aws.amazon.com/redshift/latest/dg/r_TO_CHAR.html

topic 'Timestamp without timezone' DB type does not work with tRedshiftInput Schema in Talend Studio 7.1.1 in Talend Studio

'Timestamp without timezone' DB type does not work with tRedshiftInput Schema in Talend Studio 7.1.1

Re: 'Timestamp without timezone' DB type does not work with tRedshiftInput Schema in Talend Studio 7.1.1