You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Mirek Szymanski (JIRA)" <ji...@apache.org> on 2015/09/14 11:28:48 UTC

[jira] [Created] (SQOOP-2568) Problem with Teradata input table with TIMESTAMP columns

Mirek Szymanski created SQOOP-2568:
--------------------------------------

             Summary: Problem with Teradata input table with TIMESTAMP columns
                 Key: SQOOP-2568
                 URL: https://issues.apache.org/jira/browse/SQOOP-2568
             Project: Sqoop
          Issue Type: Bug
    Affects Versions: 1.99.6
            Reporter: Mirek Szymanski



While transferring data between Teradata and Oracle databases, exception is thrown in case of Timestamp column type.

(This is similar problem to SQOOP-2564, but here the exception is thrown from loader, not from extractor)

2015-09-14 10:48:48,323 INFO [AsyncDispatcher event handler] org.apache.hadoop.mapreduce.v2.app.job.impl.TaskAttemptImpl: Diagnostics report from attempt_1441804561641_0238_m_000001_0: Error: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0018:Error occurs during loader run
	at org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:261)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ClassCastException: org.joda.time.LocalDateTime cannot be cast to org.joda.time.DateTime
	at org.apache.sqoop.connector.jdbc.GenericJdbcExecutor.addBatch(GenericJdbcExecutor.java:251)
	at org.apache.sqoop.connector.jdbc.GenericJdbcLoader.load(GenericJdbcLoader.java:46)
	at org.apache.sqoop.connector.jdbc.GenericJdbcLoader.load(GenericJdbcLoader.java:25)
	at org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:250)
	... 5 more



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)