hive表锁Unable to acquire IMPLICIT, EXCLUSIVE lock

这篇博客记录了在使用 Hive 时遇到的日志错误,提示无法获取表的锁。内容包括错误日志的详细信息,如初始化日志、锁获取失败的提示以及警告信息。博主提供了检查表是否被锁住的 Hive 查询,并给出了解决锁问题的方法,即关闭 Hive 的并发支持设置(set hive.support.concurrency=false)。
摘要由CSDN通过智能技术生成

hive报错日志:

[INFO] 2021-04-07 13:35:32.351  - [taskAppId=TASK-5-103-481]:[127] -  -> Logging initialized using configuration in jar:file:/opt/cloudera/parcels/CDH-5.12.1-1.cdh5.12.1.p0.3/jars/hive-common-1.1.0-cdh5.12.1.jar!/hive-log4j.properties
	Unable to acquire IMPLICIT, EXCLUSIVE lock tmp@portrayal_user_nemo_label_day@dt=2021-04-06 after 100 attempts.
[INFO] 2021-04-07 13:35:42.856  - [taskAppId=TASK-5-103-481]:[127] -  -> FAILED: Error in acquiring locks: Locks on the underlying objects cannot be acquired. retry after some time
[INFO] 2021-04-07 13:35:43.547  - [taskAppId=TASK-5-103-481]:[127] -  -> WARN: The method class org.apache.commons.logging.impl.SLF4JLogFactory#release() was invoked.
	WARN: Please see http://www.slf4j.org/codes.html#release for an explanation.
	Wed Apr  7 13:35:43 CST 2021 Error exit !!! 
[INFO] 2021-04-07 13:35:43.547  - [taskAppId=TASK-5-103-481]:[214] - process has exited, execute path:/tmp/dolphinscheduler/exec/process/1/5/103/481, processId:5661 ,exitStatusCode:0

查看表是否被锁住:

-- hive>
use tmp;
show locks portrayal_user_nemo_label_day;

解决办法:关闭锁机制:

set hive.support.concurrency=false; 默认为true

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值