Home > other >  Sqoop will hive table content error importing mysql ~ ~ ~ for MAO
Sqoop will hive table content error importing mysql ~ ~ ~ for MAO

Time:10-23

Sqoop export - connect JDBC: mysql://192.168.1.10:3306/trans_db - the 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'
I run the above command will consult you to quote the following error
17/05/18 16:58:41 INFO graphs. Job: Counters: 12
Job Counters
Failed the map tasks=1
Killed the map tasks=3
Launched the map tasks=3
Data - local map tasks=3
The Total time spent by all maps in occupied slots (ms)=12240
The Total time spent by all reduces occupied in slots (ms)=0
The Total time spent by all the map tasks (ms)=12240
Total vcore - milliseconds seems by all the map tasks=12240
Total Megabyte - milliseconds seems by all the map tasks=12533760
The Map - Reduce Framework
The CPU time spent (ms)=0
Physical memory (in bytes) snapshot=0
Virtual memory (in bytes) snapshot=0
17/05/18 16:58:41 WARN graphs. Counters: Group FileSystemCounters is deprecated. Use org. Home. The apache hadoop. Graphs. FileSystemCounter
17/05/18 16:58:41 INFO graphs. ExportJobBase: Transferred 0 bytes in 17.0415 seconds (0 bytes/SEC)
17/05/18 16:58:41 INFO graphs. ExportJobBase: Exported 0 records.
17/05/18 16:58:41 ERROR tool. ExportTool: ERROR during the export:
Export job failed!
The at org. Apache. Sqoop. Graphs. ExportJobBase. RunExport (ExportJobBase. Java: 442)
The at org. Apache. Sqoop. Manager. SqlManager. ExportTable (SqlManager. Java: 931)
The at org. Apache. Sqoop. Tool. ExportTool. ExportTable (ExportTool. Java: 80)
The at org. Apache. Sqoop. Tool. ExportTool. Run (ExportTool. Java: 99)
The at org. Apache. Sqoop. Sqoop. Run (sqoop. Java: 147)
At org, apache hadoop. Util. ToolRunner. Run (70) ToolRunner. Java:
The at org. Apache. Sqoop. Sqoop. RunSqoop (sqoop. Java: 183)
The at org. Apache. Sqoop. Sqoop. RunTool (sqoop. Java: 234)
The at org. Apache. Sqoop. Sqoop. RunTool (sqoop. Java: 243)
At org. Apache. Sqoop. Sqoop. Main (252) sqoop. Java:

CodePudding user response:

For MAO, I also met!

CodePudding user response:

You don't solve the problem, I here is also the same mistakes, who runs in the CDH sqoop, also don't know where the problem is
  • Related