show Locks LockManager not specified解决

完整报错如下:

0: jdbc:hive2://Desktop:10000> show locks t1;
INFO  : Compiling command(queryId=appleyuchi_20200529181834_34dc2f08-7ddd-4581-97be-0c9635c87e94): show locks t1
INFO  : Concurrency mode is disabled, not creating a lock manager
INFO  : Semantic Analysis Completed
INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer), FieldSchema(name:mode, type:string, comment:from deserializer)], properties:null)
INFO  : Completed compiling command(queryId=appleyuchi_20200529181834_34dc2f08-7ddd-4581-97be-0c9635c87e94); Time taken: 0.022 seconds
INFO  : Concurrency mode is disabled, not creating a lock manager
INFO  : Executing command(queryId=appleyuchi_20200529181834_34dc2f08-7ddd-4581-97be-0c9635c87e94): show locks t1
INFO  : Starting task [Stage-0:DDL] in serial mode
ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. show Locks LockManager not specified
INFO  : Completed executing command(queryId=appleyuchi_20200529181834_34dc2f08-7ddd-4581-97be-0c9635c87e94); Time taken: 0.017 seconds
INFO  : Concurrency mode is disabled, not creating a lock manager
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. show Locks LockManager not specified (state=08S01,code=1)

解决方案如下:

$HIVE_HOME/conf/hive-site.xml中加入:

<property>
    <name>hive.support.concurrency</name>
    <value>true</value>
</property>


<property>
    <name>hive.txn.manager</name>
    <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
</property>

然后重启metastore和hiveserver2,

这样beeline中的上述报错就会消失。