Error in semantic analysis: Lock manager could not be initialized ...

[#1]

sometimes, error message on thrift server console:

FAILED: Error in semantic analysis: Lock manager could not be initialized, check hive.lock.manager Check hive.zookeeper.quorum and hive.zookeeper.client.port

background:

1. sqlserver's linked server ----odbc---->hive thrift server.

2. just run select * from sqlserver on hive tables/views, no error; when build cube by sqlserver, then this error.

any suggestions?

[#2 · Accepted solution]

Hi,

Are you using Hive Server 1 or Hive Server 2?  We strongly recommend Hive Server 2. If you are using HS2 it sounds like the Table Lock Manager is not correctly configured. The steps to do so are located on this page:

http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/latest/CDH4-Installation-Guide/c...

[#3]

I am using hive server 1.

OK, I will try hive server 2.

Thanks.