完整報錯如下:

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中的上述報錯就會消失。

總結(jié)

以上是生活随笔為你收集整理的show Locks LockManager not specified解决的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。