sqoop导出数据到mysql意义_SQOOP 导出数据到 MYSQL 报错

mysql 表的字段和 hadoop 里的表字段一样。密码和用户也对但是就是报错。导出不了。

各位有遇到这个情况吗？

关键从输出上看不到详细日志、。。。。

19/04/03 21:44:35 INFO mapreduce.Job: The url to track the job: http://cdh1:8088/proxy/application_1553483085921_3757/

19/04/03 21:44:35 INFO mapreduce.Job: Running job: job_1553483085921_3757

19/04/03 21:44:40 INFO mapreduce.Job: Job job_1553483085921_3757 running in uber mode : false

19/04/03 21:44:40 INFO mapreduce.Job: map 0% reduce 0%

19/04/03 21:44:45 INFO mapreduce.Job: map 100% reduce 0%

19/04/03 21:44:45 INFO mapreduce.Job: Job job_1553483085921_3757 failed with state FAILED due to: Task failed task_1553483085921_3757_m_000003

Job failed as tasks failed. failedMaps:1 failedReduces:0

19/04/03 21:44:45 INFO mapreduce.Job: Counters: 13

Job Counters

Failed map tasks=1

Killed map tasks=3

Launched map tasks=3

Data-local map tasks=2

Rack-local map tasks=1

Total time spent by all maps in occupied slots (ms)=40720

Total time spent by all reduces in occupied slots (ms)=0

Total time spent by all map tasks (ms)=5090

Total vcore-milliseconds taken by all map tasks=5090

Total megabyte-milliseconds taken by all map tasks=41697280

Map-Reduce Framework

CPU time spent (ms)=0

Physical memory (bytes) snapshot=0

Virtual memory (bytes) snapshot=0

19/04/03 21:44:45 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead

19/04/03 21:44:45 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 12.0892 seconds (0 bytes/sec)

19/04/03 21:44:45 INFO mapreduce.ExportJobBase: Exported 0 records.

19/04/03 21:44:45 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)