[ https://issues.apache.org/jira/browse/SQOOP-1764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Robson updated SQOOP-1764: -------------------------------- Attachment: SQOOP-1764.patch > Numeric Overflow when getting extent map > ---------------------------------------- > > Key: SQOOP-1764 > URL: https://issues.apache.org/jira/browse/SQOOP-1764 > Project: Sqoop > Issue Type: Bug > Components: connectors/oracle > Affects Versions: 1.4.5 > Reporter: David Robson > Assignee: David Robson > Attachments: SQOOP-1764.patch > > > User is receiving the following error - looks like the block ID can be bigger > than an int: > 14/11/06 14:17:58 ERROR tool.ImportTool: Encountered IOException running > import job: java.io.IOException: java.sql.SQLException: Numeric Overflow > at > com.quest.oraoop.OraOopDataDrivenDBInputFormat.getSplits(OraOopDataDrivenDBInputFormat.java:120) > at > org.apache.hadoop.mapreduce.JobSubmitter.writeNewSplits(JobSubmitter.java:498) > at > org.apache.hadoop.mapreduce.JobSubmitter.writeSplits(JobSubmitter.java:515) > at > org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:399) > at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1295) > at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1292) > 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:1614) > at org.apache.hadoop.mapreduce.Job.submit(Job.java:1292) > at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:1313) > at > org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob(ImportJobBase.java:198) > at > org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:171) > at > org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:268) > at > org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:665) > at > com.quest.oraoop.OraOopConnManager.importTable(OraOopConnManager.java:260) > at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:497) > at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) > at org.apache.sqoop.Sqoop.run(Sqoop.java:143) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227) > at org.apache.sqoop.Sqoop.main(Sqoop.java:236) > Caused by: java.sql.SQLException: Numeric Overflow > at > oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4170) > at > oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:119) > at > oracle.jdbc.driver.GeneratedStatement.getInt(GeneratedStatement.java:217) > at > oracle.jdbc.driver.GeneratedScrollableResultSet.getInt(GeneratedScrollableResultSet.java:522) > at > oracle.jdbc.driver.GeneratedResultSet.getInt(GeneratedResultSet.java:1350) > at > com.quest.oraoop.OraOopOracleQueries.getOracleDataChunksExtent(OraOopOracleQueries.java:271) > at > com.quest.oraoop.OraOopDataDrivenDBInputFormat.getSplits(OraOopDataDrivenDBInputFormat.java:74) > ... 23 more -- This message was sent by Atlassian JIRA (v6.3.4#6332)