SQOOP 导出Hive数据到MySQL报错如下错误
Export job failed!
at org.apache.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:445)
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:76)
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)
- 该问题是mysql与hive的字段类型问题或表结构问题(字段不一样或者表结构不一样引起的)
- 解决方案: 修改MySQL表中的类型和hive表的类型一样或修改表结构一样
版权声明:本文为m0_46565121原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。