HIVE SQL执行时候报return code 2错误解决方案

最新推荐文章于 2025-05-08 16:16:03 发布

小麻雀O_O

最新推荐文章于 2025-05-08 16:16:03 发布

阅读量3.2w

点赞数 2

CC 4.0 BY-SA版权

分类专栏： HIVE 文章标签： hive return code 2

本文链接：https://blog.youkuaiyun.com/wang_sheng_yong/article/details/81267174

HIVE 专栏收录该内容

1 篇文章

订阅专栏

18/07/29 00:53:04 ERROR operation.Operation: Error running hive query: 
org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
	at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:374)
	at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:180)
	at org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:72)
	at org.apache.hive.service.cli.operation.SQLOperation$2$1.run(SQLOperation.java:232)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:415)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1693)
	at org.apache.hive.service.cli.operation.SQLOperation$2.run(SQLOperation.java:245)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)

目前具体报错原因未知，可在执行sql语句前加上这句解决上面问题：

set hive.support.concurrency=false;