sqoop纠错

最新推荐文章于 2020-04-13 22:27:36 发布

仔仔1993

最新推荐文章于 2020-04-13 22:27:36 发布

阅读量51

点赞数

分类专栏：多维分析文章标签： sqoop java hive hadoop mysql

本文链接：https://blog.csdn.net/qq_26777585/article/details/109571167

版权

多维分析专栏收录该内容

35 篇文章 0 订阅

订阅专栏

###############################################################
#####sqoop向mysql导数报错
###############################################################
错误：18/02/08 10:14:59 ERROR tool.ExportTool: Error during export:
Export job failed!
   at org.apache.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:439)
   at org.apache.sqoop.manager.SqlManager.exportTable(SqlManager.java:931)
   at org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:80)
   at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:99)
   at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
   at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
   at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
   at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
   at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
   at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
解决：主要是由于hive表和mysql表中的结构不一样，字段类型，还有就是分隔符与hive表的不一致