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/17 12:49:45 UTC
[jira] [Updated] (SQOOP-2568) Problem with Teradata input table
with TIMESTAMP columns
[ 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)