sqoop error xxx is greater than xxx

最新推荐文章于 2022-04-18 21:43:33 发布

kevin_wf

最新推荐文章于 2022-04-18 21:43:33 发布

阅读量371

点赞数

分类专栏： sqoop

本文链接：https://blog.csdn.net/wflh323/article/details/105490838

版权

在执行sqoop导入时遇到错误，日志显示一个浮点数比另一个浮点数大，导致IOException。错误源于在DataDrivenDBInputFormat类中的split方法中，使用了非数字类型字段值进行split操作。解决办法是检查SQL查询语句，确保用于split的字段值为数字类型。

摘要由CSDN通过智能技术生成

sqoop导数失败，异常日志：

java.io.IOException: 0.00149538554284945409038360094760876373868438891233028512477697236907921983118594701374880207023210232364363037049770355224609375 is greater than 0.001281757140869648262434488801267003365970469023032400173426768338316728763538149640267838069718209226266480982303619384765625
20/03/27 03:30:34 ERROR tool.MyImportTool: Encountered IOException running import job: java.io.IOException: 0.00149538554284945409038360094760876373868438891233028512477697236907921983118594701374880207023210232364363037049770355224609375 is greater than 0.001281757140869648262434488801267003365970469023032400173426768338316728763538149640267838069718209226266480982303619384765625
   at org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:204)
   at org.apache.hadoop.mapreduce.JobSubmitter.writeNewSplits(JobSubmitter.java:305)
   at org.apache.hadoop.mapreduce.JobSubmitter.writeSplits(Jo