Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Error in semantic analysis: Lock manager could not be initialized


Copy link to this message
-
Error in semantic analysis: Lock manager could not be initialized
here is my hive config file,i do not know why,anyone can help?

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://192.168.10.118/metastore</value>
  <description>the URL of the MySQL database</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>hive</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>myhive</value>
</property>
<property>
  <name>datanucleus.autoCreateSchema</name>
  <value>false</value>
</property>
<property>
  <name>datanucleus.fixedDatastore</name>
  <value>true</value>
</property>
<property>
  <name>datanucleus.autoStartMechanism</name>
  <value>SchemaTable</value>
</property>
<property>
  <name>hive.metastore.uris</name>
  <value>thrift://192.168.10.22:9083</value>
</property>
<property>
  <name>hive.metastore.warehouse.dir</name>
  <value>/user/hive/warehouse</value>
</property>
<property>
  <name>hive.aux.jars.path</name>

<value>file:///usr/lib/hive/lib/hive-hbase-handler-0.10.0-cdh4.3.0.jar,file:///usr/lib/hive/lib/hbase.jar,file:///usr/lib/hive/lib/zookeeper.jar</value>
</property>
<property>
  <name>hive.zookeeper.quorum</name>
  <value>192.168.10.22:2281</value>
</property>
<property>
  <name>hive.hwi.listen.host</name>
  <value>0.0.0.0</value>
  <description>This is the host address the Hive Web Interface will listen
on</description>
</property>
<property>
  <name>hive.hwi.listen.port</name>
  <value>8888</value>
  <description>This is the port the Hive Web Interface will listen
on</description>
</property>
<property>
  <name>hive.hwi.war.file</name>
  <value>lib/hive-hwi-0.7.1-cdh3u4.war</value>
  <description>This is the WAR file with the jsp content for Hive Web
Interface</description>
</property>
<property>
  <name>hive.support.concurrency</name>
  <value>true</value>
</property>
<property>
  <name>hive.zookeeper.client.port</name>
  <value>2281</value>
</property>
<property>
  <name>hive.lock.manager</name>

<value>org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockManager</value>
</property>
</configuration>

hive> show tables;
FAILED: Error in semantic analysis: Lock manager could not be initialized,
check hive.lock.manager Check hive.zookeeper.quorum and
hive.zookeeper.client.port
OK
demo_hive