Sqoop：Error during export:Export job failed !
sqoop export data to mysql exception, usually are very normal today can not, there is nothing to report error information, is not very depressed.
21/08/25 15:03:05 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)

Several possibilities
1, conversion: the null problem requires conversion
–input-fields-terminated-by ‘\001’
–input-null-string ‘\N’
–input-null-non-string ‘\N’
2, table structure inconsistencies, hive table fields mysql table must have, mysql fields can be more not less
3, mysql table field length to less, change the structure on the good

Read More:

• RuntimeError: ONNX export failed: Couldn‘t export operator aten::upsample_bilinear2d
• Sqoop exports hive data to MySQL Error [How to Solve]
• POI Export Excel Error: HTTP Status 500 – Request processing failed; nested exception is java.lang.NullPointerException
• [Solved] Ureport2 export word error: unable to access this website
• How to Solve Android jetpack Room Schema export Error
• Sqoop Error: Can‘t parse input data: ‘\N‘ [How to Solve]
• [Solved] Vue3 Error: export ‘createRouter‘ was not found in ‘vue-router‘
• [Solved] Vscode Error: “export ‘default‘ (imported as ‘VueRouter‘) was not found in ‘vue-router‘
• Attempted import error: ‘mobx-react‘ does not contain a default export (imported as ‘observer‘).
• Tencent cloud container easyexcel export excel error NoClassDefFoundError: could not initialize class sun.awt.x11fontmanager
• [Solved] Response Export error on submit request on future invoke, java.lang.OutOfMemoryError: Java heap space
• Echars 5.0 Import Error: “export ‘default’ (imported as ‘echarts’) was not found in ‘echarts’
• [Solved] Mac Unity Export Android Project Error: Error building Player: Win32Exception
• [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
• [Solved] sqoop Error: jSQLException in nextKeyValue Caused by: ORA-24920:column size too large for client
• Sqoop connection gbase data error [How to Solve]
• MAC-XXL_JOB Error: Failed to create parent directories for [/data/applogs/xxl-job/xxl-job-admin.log
• [Solved] Job for mysqld.service failed because the control process exited with error code.
• [Solved] Job for docker.service failed because the control process exited with error
• [Solved] CentOS build a docker error: job for docker.service failed….