sqoop 将hive表内容导入mysql 出错~~~为毛啊

2017-05-18 05:10:03 2.4k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

大数据组件工具——数据导入导出 Sqoop Sqoop是一款Apache旗下的ETL工具，主要用于Hadoop与关系型数据库之间的数据传输。它能将MySQL、Oracle等数据导入HDFS、Hive、HBase，或将Hadoop数据导出到关系库。Sqoop通过将命令翻译为MapReduce任务实现数据传输，并定制化InputFormat和OutputFormat。Sqoop1采用客户端直接提交方式，而Sqoop2引入集中化管理的Server端，支持REST API和WebUI，安全性更高。安装需配置环境变量、依赖库及Hadoop组件路径。常用操作包括阅读详情

sqoop export --connect jdbc:mysql://192.168.1.10:3306/trans_db --username root --password root --table ex_trans --export-dir /user/hive/warehouse/ga_mis.db/ex_tst_like --input-fields-terminated-by '\t' --input-lines-terminated-by '\n'
我运行上述命令会报如下错误请教您一下
17/05/18 16:58:41 INFO mapreduce.Job: Counters: 12
Job Counters
Failed map tasks=1
Killed map tasks=3
Launched map tasks=3
Data-local map tasks=3
Total time spent by all maps in occupied slots (ms)=12240
Total time spent by all reduces in occupied slots (ms)=0
Total time spent by all map tasks (ms)=12240
Total vcore-milliseconds taken by all map tasks=12240
Total megabyte-milliseconds taken by all map tasks=12533760
Map-Reduce Framework
CPU time spent (ms)=0
Physical memory (bytes) snapshot=0
Virtual memory (bytes) snapshot=0
17/05/18 16:58:41 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
17/05/18 16:58:41 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 17.0415 seconds (0 bytes/sec)
17/05/18 16:58:41 INFO mapreduce.ExportJobBase: Exported 0 records.
17/05/18 16:58:41 ERROR tool.ExportTool: Error during export:
Export job failed!
at org.apache.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:442)
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)

...全文