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!
