The following error is reported when exporting hive data from sqoop to MySQL
Export job failed!
at org.apache.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:445)
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:76)
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)
This problem is caused by the field type problem or table structure problem between MySQL and hive (the fields are different or the table structure is different).
Solution: modify the type in MySQL table to be the same as that in hive table or modify the table structure
Read More:
- Sqoop Error: Error during export:Export job failed [How to Solve]
- Sqoop Error: Can‘t parse input data: ‘\N‘ [How to Solve]
- [Solved] Flink jdbc Error: Access Denied for user ‘root‘@‘10.0.0.x‘ (using password: YES)
- Initial installation of hive-2.1.0 startup error problem solution
- [Solved] Hive 2.3.9 Error: Error: Unrecognized column type: UNIONTYPE (state=,code=0)
- [Solved] sqoop Error: jSQLException in nextKeyValue Caused by: ORA-24920:column size too large for client
- Centos7 hive started to report an error. There is no route to the host. The firewall has been closed
- [Solved] Schema initialization FAILED Metastore state would be inconsistent
- Hive ERROR Failed with exception java.io.IOException:java.lang.IllegalArgumentException
- TypeException: Error setting non null for parameter #1 with JdbcType null
- [Solved] Hive Error: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- [Solved] Hive tez due to: ROOT_INPUT_INIT_FAILURE java.lang.IllegalArgumentException: Illegal Capacity: -38297
- Hive 3.1.2 startup error reporting and resolution of guava version conflict
- Apache Altas Compile Error: [ERROR] Failed to execute goal on project atlas-testtools: Could not resolve
- [Solved] NoClassDefFoundError: jline/console/completer/ArgumentCompleter$ArgumentDelimiter
- [Solved] bin/hive Startup Error: Operation category READ is not supported in state standby
- Doris BrokerLoad Error: quality not good enough to cancel
- Doris BrokerLoad Error: quality not good enough to cancel
- [Solved] Failed update hbase:meta table descriptor HBase Startup Error