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)