Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

I am getting following exception while loading data from hdfs to teradata using hortonworks teradata connector, java.lang.RuntimeException: Unparseable date: "2016-01-19 02:00:00"

Highlighted

I am getting following exception while loading data from hdfs to teradata using hortonworks teradata connector, java.lang.RuntimeException: Unparseable date: "2016-01-19 02:00:00"

New Contributor

I am getting following exception while loading data from hdfs to teradata using hortonworks teradata connector,

java.lang.RuntimeException: Unparseable date: "2016-01-19 02:00:00"

at com.teradata.connector.common.converter.ConnectorDataTypeConverter$StringFMTTZToTimestampTZ.convert(ConnectorDataTypeConverter.java:1679)

at com.teradata.connector.teradata.converter.TeradataConverter.convert(TeradataConverter.java:143)

at com.teradata.connector.common.ConnectorOutputFormat$ConnectorFileRecordWriter.write(ConnectorOutputFormat.java:106)

at com.teradata.connector.common.ConnectorOutputFormat$ConnectorFileRecordWriter.write(ConnectorOutputFormat.java:65)

3 REPLIES 3

Re: I am getting following exception while loading data from hdfs to teradata using hortonworks teradata connector, java.lang.RuntimeException: Unparseable date: "2016-01-19 02:00:00"

Re: I am getting following exception while loading data from hdfs to teradata using hortonworks teradata connector, java.lang.RuntimeException: Unparseable date: "2016-01-19 02:00:00"

New Contributor

@Rajkumar Singh

How to set <property>

<name>tdch.input.timestamp.format</name> <value>yyyy-MM-dd HH:mm:ss</value> <description>Port that this metastore should listen on. </description> </property>

from command line

Re: I am getting following exception while loading data from hdfs to teradata using hortonworks teradata connector, java.lang.RuntimeException: Unparseable date: "2016-01-19 02:00:00"

please add this in teradata-export-properties.xml

Don't have an account?
Coming from Hortonworks? Activate your account here