[
https://issues.apache.org/jira/browse/SQOOP-2568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mirek Szymanski updated SQOOP-2568:
-----------------------------------
Environment: Teradata 13, Oracle 11g
Description:
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
was:
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
> 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
> Environment: Teradata 13, Oracle 11g
> 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)
