[jira] [Commented] (SQOOP-1764) Numeric Overflow when getting extent map

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SQOOP-1764?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14217387#comment-14217387 ] 

ASF subversion and git services commented on SQOOP-1764:
--------------------------------------------------------

Commit eceff4c8f42df5a4f13ea5bf69eb33c3020f12a3 in sqoop's branch refs/heads/trunk from [~venkatnrangan]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=eceff4c ]

SQOOP-1764: Numeric Overflow when getting extent map
(David Robson via Venkat Ranganathan)


> 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)