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

amyliushu 2017-05-18 05:10:03

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)

...全文