【hive】INFO hive.HiveImport: FAILED: Execution Error, return code 1 from org.apache

最新推荐文章于 2026-04-21 19:24:43 发布

原创

最新推荐文章于 2026-04-21 19:24:43 发布 · 5.7k 阅读

收录于

当前文章被以下社区和专栏收录：

20/09/24 14:38:37 INFO hive.HiveImport: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:An exception was thrown while adding/validating class(es) : Column length too big for column 'PARAM_VALUE' (max = 21845); use BLOB or TEXT instead

这个问题我是在操作使用sqoop从mysql将数据库表及数据导入到hive数据库中出现的

问题出在了hive

在hive中创建表也同样出现这个错误

sqoop下边报的错误是这样的

20/09/24 14:38:37 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Hive exited with status 1
        at org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:389)
        at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:339)
        at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:240)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:514)
        at org.apache.sqo