Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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?

1 ACCEPTED SOLUTION

avatar
Contributor


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...

View solution in original post

2 REPLIES 2

avatar
Contributor


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...

avatar
Explorer

I am using hive server 1.

OK, I will try hive server 2.

Thanks.