Our data source is redshift and we are using redshift translator in JDV.
The source table has a couple of fields with data type "timestamp with timezone". This is field is mapped to Teiid source model with a data type timestamp. For some reason we are receiving following error when running a query on the table with this field in VDB.

"SQL Error [30504] [50000]: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 SRC_RS_HYDRA: 22003 Unexpected exception while translating results: [Amazon][JDBC](10140) Error converting value to Timestamp"

The fields which have source data type of "timestamp without timezone" mapped to teiid data type of timestamp work just fine.

Please let me know if you have any questions.

Thanks,
Chandra