Hi Yandex, what Sqoop version are you using? Would you mind sharing with us failed Map task log? It usually contains also the chained exceptions with more information about the failure.
Jarcec On Mon, Oct 14, 2013 at 03:44:34PM +0700, Yandex Mail wrote: > 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) > > ) > > > > >
signature.asc
Description: Digital signature
