hive lock报错
FAILED: Error in acquiring locks: Locks on the underlying objects cannot be acquired. retry after some time解决办法:关闭并发,set hive.support.concurrency=false;
hive锁介绍:
hive存在两种锁,共享锁Shared (S)和互斥锁Exclusive (X),
其中只触发s锁的操作可以并发的执行,只要有一个操作对表或者分区出发了x锁,则该表或者分区不能并发的执行作业。
各个操作锁出发的锁如下:
Hive Command |
Locks Acquired |
select .. T1 partition P1 |
S on T1, T1.P1 |