hdfs mysql sqoop 失败_sqoop从hdfs导入到mysql 报ERROR tool.ExportTool: Error during export: Export job faile...

楼主需要把hdfs上的数据导入到mysql当中，报如下错误。

18/11/22 16:04:37 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:92)

at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:111)

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)

具体问题是数据中有中文，而数据库表编码不支持

解决方案如下：

将表的数据导出，删除表后重新创建表，指定编码DEFAULT CHARSET=utf8