Hive表解锁
一、完整错误
错误如下:
2021-06-11 08:46:39,227 [main] ERROR org.apache.hadoop.hive.ql.Driver - FAILED: Error in acquiring locks: Locks on the underlying objects cannot be acquired. retry after some time
org.apache.hadoop.hive.ql.lockmgr.LockException: Locks on the underlying objects cannot be acquired. retry after some time
二、查询锁表类型
hive> show locks ods_prod.charge_partition_1h;
OK
ods_prod@charge_partition_1h SHARED
Time taken: 2.301 seconds, Fetched: 1 row(s)
三、表删除锁
hive> unlock table ods_prod.charge_partition_1h;
OK
Time taken: 0.077 seconds
确认表是否成功删除锁
hive> show locks ods_prod.charge_partition_1h;
OK
Time taken: 0.054 seconds
四、表分区删除锁
查看表分区锁
hive> show locks ods_prod.acharge_partition_1h partition(dat