lvchuanwen created SQOOP-2586:
---------------------------------
Summary: oracle DATE type error
Key: SQOOP-2586
URL: https://issues.apache.org/jira/browse/SQOOP-2586
Project: Sqoop
Issue Type: Bug
Components: connectors/generic
Affects Versions: 1.99.6
Environment: Table :
CREATE TABLE "SYSTEM"."POC_ZX_OBJECTS_2" (
"OWNER" VARCHAR2(128) NULL,
"OBJECT_NAME" VARCHAR2(128) NULL,
"SUBOBJECT_NAME" VARCHAR2(128) NULL,
"OBJECT_ID" NUMBER NULL,
"DATA_OBJECT_ID" NUMBER NULL,
"OBJECT_TYPE" VARCHAR2(23) NULL,
"CREATED" DATE NULL,
"LAST_DDL_TIME" DATE NULL,
"TIMESTAMP" VARCHAR2(19) NULL,
"STATUS" VARCHAR2(7) NULL,
"TEMPORARY" VARCHAR2(1) NULL,
"GENERATED" VARCHAR2(1) NULL,
"SECONDARY" VARCHAR2(1) NULL,
"NAMESPACE" NUMBER NULL,
"EDITION_NAME" VARCHAR2(128) NULL,
"SHARING" VARCHAR2(13) NULL,
"EDITIONABLE" VARCHAR2(1) NULL,
"ORACLE_MAINTAINED" VARCHAR2(1) NULL
)
GO
Test example:
INSERT INTO SYSTEM.POC_ZX_OBJECTS_2(OWNER, OBJECT_NAME, SUBOBJECT_NAME,
OBJECT_ID, DATA_OBJECT_ID, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP,
STATUS, TEMPORARY, GENERATED, SECONDARY, NAMESPACE, EDITION_NAME, SHARING,
EDITIONABLE, ORACLE_MAINTAINED)
VALUES('', '', '', 0, 0, '', SYSDATE, SYSDATE, '', '', '', '', '', 0, '',
'', '', '')
GO
sqoop job execute from oracle to hdfs ,everything is ok.
use hadoop cat .the hfds file content is
[mr@dap231 ~]$ /home/hdfs/hdfs/bin/hadoop fs -cat
/wzc/767bdbc3-cb0f-4b86-a025-0150bfd96ec5.txt
NULL,NULL,NULL,0,0,NULL,'2015-09-22 14:39:33.000','2015-09-22
14:39:33.000',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL
but execute job from hdfs to oracle .there are some error.
2015-09-22 10:54:20,658 [OutputFormatLoader-consumer] ERROR
org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor - Error while loading
data out of MR job.
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:190)
at
org.apache.sqoop.connector.jdbc.GenericJdbcLoader.load(GenericJdbcLoader.java:50)
at
org.apache.sqoop.connector.jdbc.GenericJdbcLoader.load(GenericJdbcLoader.java:25)
at
org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:250)
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)
2015-09-22 10:54:20,658 ERROR [OutputFormatLoader-consumer]
mr.SqoopOutputFormatLoadExecutor (SqoopOutputFormatLoadExecutor.java:run(257))
- Error while loading data out of MR job.
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:190)
at
org.apache.sqoop.connector.jdbc.GenericJdbcLoader.load(GenericJdbcLoader.java:50)
at
org.apache.sqoop.connector.jdbc.GenericJdbcLoader.load(GenericJdbcLoader.java:25)
at
org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:250)
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)
2015-09-22 10:54:20,662 [LocalJobRunner Map Task Executor #0] INFO
org.apache.sqoop.job.mr.SqoopMapper - Stopping progress service
2015-09-22 13:05:41,494 INFO [LocalJobRunner Map Task Executor #0]
hdfs.HdfsExtractor (HdfsExtractor.java:extractTextFile(169)) - Start position: 0
2015-09-22 13:05:41,515 [OutputFormatLoader-consumer] ERROR
org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor - Error while loading
data out of MR job.
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)
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)
2015-09-22 13:05:41,515 ERROR [OutputFormatLoader-consumer]
mr.SqoopOutputFormatLoadExecutor (SqoopOutputFormatLoadExecutor.java:run(257))
- Error while loading data out of MR job.
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)
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)
Reporter: lvchuanwen
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
