Hi all,
I have some issue with sqoop import can you help me with it?
For this command:
sqoop import --connect jdbc:oracle:thin:@//devdb:1521/DEV --username SYSTEM
--table DEV.TEST -P --split-by id --target-dir /user/oracle/sqoopImport/
I got exception:
INFO mapred.JobClient: Task Id : attempt_201309251246_0160_m_000000_2,
Status : FAILED
java.io.IOException: SQLException in nextKeyValue
at
org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.jav
a:266)
at
org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTas
k.java:483)
at
org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.
java:76)
at
org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(Wrapp
edMapper.java:85)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:139)
at
org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64
)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330)
at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.ja
va:1408)
at org.apache.hadoop.mapred.Child.main(Child.java:262)
Caused by: java.sql
Table have 272 348 767 rows
DDL for table:
CREATE TABLE "DEV"."TEST "
( "ID" NUMBER(19,0) NOT NULL ENABLE,
"TIME" TIMESTAMP (6) NOT NULL ENABLE,
"COL1" VARCHAR2(1000) NOT NULL ENABLE,
"COL2" VARCHAR2(1000) NOT NULL ENABLE,
"COL3" VARCHAR2(1000),
"COL4" VARCHAR2(1000),
"COL5" VARCHAR2(1000),
"COL6" VARCHAR2(1000),
"COL7" VARCHAR2(1000),
"COL8" VARCHAR2(1000),
"COL9" VARCHAR2(1000),
"COL10" VARCHAR2(1000),
"COL11" VARCHAR2(1000),
"COL12" VARCHAR2(1000),
"COL13" VARCHAR2(1000),
"COL14" VARCHAR2(1000),
"COL15" VARCHAR2(1000),
"REQUEST " NUMBER(19,0)
)
