Error with Redshift Timestamp

One Star

Error with Redshift Timestamp

I'm encountering the following error doing a bulk insert to redshift:
Exception in component tRedshiftOutputBulkExec_1_tRBE
java.sql.SQLException: (500310) Invalid operation: timestamp or timestamptz do not support precision.;
Any idea what it is?
One Star

Re: Error with Redshift Timestamp

This may or may not be of use to you, but I ran into the same problem trying to create a table today.
The reason in my case, was trying to create a table with a timestamp field that was defaulting to CURRENT_TIMESTAMP. My theory is the redshift implementation tries to implement this in the underlying postgres nodes by using timestampz and that's not being supported by whatever version of postgres they use (aka a bug on their side). 
In my case, I was loading a massive dump of data that all included timestamps, so I could get around it by setting DEFAULT NULL on the table definition.
One Star

Re: Error with Redshift Timestamp

Upon further exploration, the equivalent of CURRENT_TIMESTAMP is SYSDATE. That also works.
What doesn't work are the AWS Data Pipeline scripts to go from mysql to redshift.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now


Introduction to Talend Open Studio for Data Integration.


Downloads and Trials

Test drive Talend's enterprise products.


Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.