列出相关查看锁表语句:
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 tablename;
操作:
hive> show locks t_real_user_comein;
hive> unlock table t_real_user_comein;
OK
Time taken: 0.073 seconds
hive> drop table t_real_user_comein;
OK
Time taken: 0.216 seconds