09-12-2013 10:01 AM - last edited on 09-20-2013 08:32 AM by Clint
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
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.
09-20-2013 08:42 AM
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: