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)

Reply via email to