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]
- Sqoop connection gbase data error [How to Solve]
- Hive Error: FAILED: RuntimeException Error loading hooks(hive.exec.post.hooks): java.lang.ClassNotFoundException: org.apache.atlas.hive.hook.HiveHook
- [Solved] Hive Error: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- Hive: Hive partition sorting error [How to Solve]
- [Solved] sqoop Error: jSQLException in nextKeyValue Caused by: ORA-24920:column size too large for client
- How to Solve canal & MYSQL or “Kafka cannot consume data” Error
- Centos7 hive started to report an error. There is no route to the host. The firewall has been closed
- [Solved] swiper Error: The requested module ‘react’ is expected to be of type CommonJS, which does not support named exports. CommonJS modules can be imported by importing the default export
- Exception: logstash:: pluginloadingerror when importing MySQL data into es in Windows
- [Solved] Hive tez due to: ROOT_INPUT_INIT_FAILURE java.lang.IllegalArgumentException: Illegal Capacity: -38297
- Uncaught (in promise) Error: Delete success at __webpack_exports__.default 405 error
- [Solved] Failed to load response data: no data found for resource with given identifier
- [Solved] MYSQLD: Can‘t create directory ‘/usr/local/mysql/data/’(Errcode:2 -No such file or directory)
- [Solved] waterdrop Import hive to clickhouse Error: Too many partitions for single INSERT block (more than 100).
- Initial installation of hive-2.1.0 startup error problem solution
- Hive 3.1.2 startup error reporting and resolution of guava version conflict