Hey there, This seems like https://issues.apache.org/jira/browse/SQOOP-2098. It's still open unfortunately. We need to verify this is still an issue in later versions of Sqoop2 first. Have you tries Sqoop 1.99.6?
-Abe On Wed, Sep 16, 2015 at 2:32 PM Ted Dong <[email protected]> wrote: > Hi, > > I am using Sqoop2 v.1.99.4 on CDH 5.3 and I am trying to extract data from > an Oracle table. > > I am getting the following error: > > 2015-09-16 12:26:03,311 INFO [main] > org.apache.sqoop.connector.jdbc.GenericJdbcExtractor: Using query: SELECT * > FROM MYSCHEMA.MYTABLE WHERE '401K' <= PRIMARY_CLASS_CD AND PRIMARY_CLASS_CD > <= 'Z' > 2015-09-16 12:26:03,466 DEBUG [main] org.apache.sqoop.job.mr.SqoopMapper: > Extracted data: > '401K','401(k)','null','null',1,'null','null','N','Y','N','null','null',null,null,2014-05-25 > 00:00:00.0,-53099,null,'RETIREMENT','N','Y','BOTH' > 2015-09-16 12:26:03,614 INFO [main] org.apache.sqoop.job.mr.SqoopMapper: > Stopping progress service > 2015-09-16 12:26:03,614 INFO [main] org.apache.hadoop.mapred.MapTask: > Starting flush of map output > 2015-09-16 12:26:03,626 INFO [main] org.apache.hadoop.io.compress.CodecPool: > Got brand-new compressor [.snappy] > 2015-09-16 12:26:03,633 WARN [main] org.apache.hadoop.mapred.YarnChild: > Exception running child : org.apache.sqoop.common.SqoopException: > MAPRED_EXEC_0017:Error occurs during extractor run > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:99) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:415) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1642) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163) > Caused by: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0013:Cannot > write to the data writer > at > org.apache.sqoop.job.mr.SqoopMapper$SqoopMapDataWriter.writeContent(SqoopMapper.java:148) > at > org.apache.sqoop.job.mr.SqoopMapper$SqoopMapDataWriter.writeArrayRecord(SqoopMapper.java:122) > at > org.apache.sqoop.connector.jdbc.GenericJdbcExtractor.extract(GenericJdbcExtractor.java:62) > at > org.apache.sqoop.connector.jdbc.GenericJdbcExtractor.extract(GenericJdbcExtractor.java:31) > at org.apache.sqoop.job.mr.SqoopMapper.run(SqoopMapper.java:94) > ... 7 more > Caused by: java.lang.IllegalArgumentException: Invalid format: "null" > at > org.joda.time.format.DateTimeFormatter.parseLocalDateTime(DateTimeFormatter.java:854) > at org.joda.time.LocalDateTime.parse(LocalDateTime.java:168) > at org.joda.time.LocalDateTime.parse(LocalDateTime.java:157) > at > org.apache.sqoop.connector.idf.CSVIntermediateDataFormat.getObjectData(CSVIntermediateDataFormat.java:228) > at > org.apache.sqoop.job.mr.SqoopMapper$SqoopMapDataWriter.writeContent(SqoopMapper.java:143) > ... 11 more > > > This is the table I am extracting from: > > MYTABLE > > COL1 VARCHAR2(10) > COL2 VARCHAR2(100) > COL3 VARCHAR2(1) > COL4 VARCHAR2(1) > COL5 NUMBER(22,2) > COL6 VARCHAR2(1) > COL7 VARCHAR2(1) > COL8 VARCHAR2(1) > COL9 VARCHAR2(1) > COL10 VARCHAR2(1) > COL11 VARCHAR2(20) > COL12 VARCHAR2(20) > COL13 DATE > COL14 NUMBER(22,10) > COL15 DATE > COL16 NUMBER(22,10) > COL17 DATE > COL18 VARCHAR2(10) > COL19 VARCHAR2(1) > COL20 VARCHAR2(1) > COL21 VARCHAR2(20) > > Any help would be greatly appreciated! > > >
