sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Error extracting from Oracle
Date Thu, 17 Sep 2015 21:01:12 GMT
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 <tdong@splicemachine.com> 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!
> ​
>
>

Mime
View raw message