FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Current transaction manager does not support explicit lock requests. Transaction manager:
操作系统:CentOS Linux release 7.4.1708 (Core) 研发环境 软件环境:cdh5.15.1 开启了事务认证 记录时间:20190729 1、查看是否有表被锁: show locks show locks table_name 2、#解决办法 unlock table table_name unlock table table_name partition(dt='2014-04-01'); 3、 在解决过程中遇到报错: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
Current transaction manager does not support explicit lock requests. Transaction manager:
org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
这是由于开启了事务,不支持这种命令,开启事务详细见10.1如何开启事物Transaction机制 将事务机制关闭即可进行删除。 4、实际测试发现,关闭事务的时候,集群发生重启,这个锁自动关闭了。