sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yandex Mail" <Skiv1...@ya.ru>
Subject sqopp import issue
Date Mon, 14 Oct 2013 08:44:34 GMT
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)

   )

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message