查看锁表语句:
- SHOW LOCKS <TABLE_NAME>;
- SHOW LOCKS <TABLE_NAME> extended;
- SHOW LOCKS <TABLE_NAME> PARTITION (<PARTITION_DESC>);
- SHOW LOCKS <TABLE_NAME> PARTITION (<PARTITION_DESC>) extended
关闭锁机制:
set hive.support.concurrency=false; 默认为true
解锁:
unlock table 表名; – 解锁表
unlock table 表名 partition(dt=‘20190919’); – 解锁某个分区
注意:
表锁和分区锁是两个不同的锁,对表解锁,对分区是无效的,分区需要单独解锁