Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-1764

Numeric Overflow when getting extent map

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.5
    • Fix Version/s: 1.4.6
    • Component/s: connectors/oracle
    • Labels:
      None

      Description

      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

        Attachments

        1. SQOOP-1764.patch
          6 kB
          David Robson

          Issue Links

            Activity

              People

              • Assignee:
                david.robson David Robson
                Reporter:
                david.robson David Robson
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: