Apache Hive事务分桶表插入数据失败：解锁权限异常求助

尝试通过Beeline和Apache HUE向分桶事务表插入数据，报错提示不允许解锁锁，同时触发元数据通信异常的LockException。

执行的SQL语句 #

SET hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
SET hive.support.concurrency=true;
SET hive.enforce.bucketing=true;
SET hive.exec.dynamic.partition.mode=nonstrict;


USE classicmodels;

CREATE TABLE classicmodels.my_emp (ID INT, Name STRING, Salary INT)
CLUSTERED BY (ID) INTO 5 BUCKETS
STORED AS ORC
TBLPROPERTIES('transactional'='true');

INSERT INTO TABLE classicmodels.my_emp (id, name, salary)
VALUES (1, 'John', 10000),
       (2, 'Sara', 12000),
       (3, 'Adam', 8000);

错误详情 #

• Beeline报错：提示“不允许解锁锁”，且元数据中存在未释放的锁
• HUE报错信息：

org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error communicating with the metastore) at org.apache.hive.service.cli.operation.Operation.toSQ...

内容的提问来源于stack exchange，提问作者VCTR