Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9A0FA10F6D for ; Wed, 10 Jul 2013 06:21:31 +0000 (UTC) Received: (qmail 96098 invoked by uid 500); 10 Jul 2013 06:21:29 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 95861 invoked by uid 500); 10 Jul 2013 06:21:29 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 95853 invoked by uid 99); 10 Jul 2013 06:21:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jul 2013 06:21:28 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_LOW,SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of justlooks@gmail.com designates 209.85.216.49 as permitted sender) Received: from [209.85.216.49] (HELO mail-qa0-f49.google.com) (209.85.216.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jul 2013 06:21:21 +0000 Received: by mail-qa0-f49.google.com with SMTP id hu16so3360082qab.8 for ; Tue, 09 Jul 2013 23:21:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=/TfA2HSa59yqruqYfkum9LJtT7K7tHpUFfeW34Aybd8=; b=bP02YgGFnaJTVeI97CsuduU7eBu1SIaxTB9xTeQESPsdcCOr6MSrZ9SGxxPFHzuu9y P/onm4wLOVj20x978A3R4JMjf+v6GML4EZ/AocR4Z+DkcXFsISW7g0oeOOdRnxFxC6ra 4aLpwacLCJ0t96XMBoR9ttGIMM5Ryqa023o2KniaVq7qCTm5rbU0PQycuZpCmbUqw+J5 KVxth3VKs6wr35ih/LeZzogDBmkIuf9SI3ylh/1kmkWvsJfxVQhMVZOmj/1Vao+B1Tby 0tHfThv3hxEs4qoIbsDMguU8jIuMpYBZXeKfgJMgHpoGBpIix64xJN3sfil3SgR+e3d9 oSMA== MIME-Version: 1.0 X-Received: by 10.49.83.37 with SMTP id n5mr23663241qey.57.1373437261175; Tue, 09 Jul 2013 23:21:01 -0700 (PDT) Received: by 10.224.191.74 with HTTP; Tue, 9 Jul 2013 23:21:01 -0700 (PDT) Date: Wed, 10 Jul 2013 14:21:01 +0800 Message-ID: Subject: Error in semantic analysis: Lock manager could not be initialized From: ch huang To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7b6da16612e22a04e122481d X-Virus-Checked: Checked by ClamAV on apache.org --047d7b6da16612e22a04e122481d Content-Type: text/plain; charset=ISO-8859-1 here is my hive config file,i do not know why,anyone can help? javax.jdo.option.ConnectionURL jdbc:mysql://192.168.10.118/metastore the URL of the MySQL database javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver javax.jdo.option.ConnectionUserName hive javax.jdo.option.ConnectionPassword myhive datanucleus.autoCreateSchema false datanucleus.fixedDatastore true datanucleus.autoStartMechanism SchemaTable hive.metastore.uris thrift://192.168.10.22:9083 hive.metastore.warehouse.dir /user/hive/warehouse hive.aux.jars.path 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 hive.zookeeper.quorum 192.168.10.22:2281 hive.hwi.listen.host 0.0.0.0 This is the host address the Hive Web Interface will listen on hive.hwi.listen.port 8888 This is the port the Hive Web Interface will listen on hive.hwi.war.file lib/hive-hwi-0.7.1-cdh3u4.war This is the WAR file with the jsp content for Hive Web Interface hive.support.concurrency true hive.zookeeper.client.port 2281 hive.lock.manager org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockManager 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 --047d7b6da16612e22a04e122481d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
here is my hive config file,i do not know why,anyone can help?
=A0
<property>
=A0 <name>javax.jdo.option.ConnectionURL<= /name>
=A0 <value>jdbc:mysql://192.168.10.118/metastore</value>
=A0 <descripti= on>the URL of the MySQL database</description>
</property>
<property>
=A0 <name>javax.jdo.option.ConnectionDriverN= ame</name>
=A0 <value>com.mysql.jdbc.Driver</value></property>
<property>
=A0 <name>javax.jdo.option.ConnectionUserNam= e</name>
=A0 <value>hive</value>
</property><= /div>
<property>
=A0 <name>javax.jdo.option.ConnectionPasswor= d</name>
=A0 <value>myhive</value>
</property>= ;
<property>
=A0 <name>datanucleus.autoCreateSchema</n= ame>
=A0 <value>false</value>
</property>
<property>
=A0 <name>datanucleus.fixedDatastore</nam= e>
=A0 <value>true</value>
</property>
<property>
=A0 <name>datanucleus.autoStartMechanism<= /name>
=A0 <value>SchemaTable</value>
</property>= ;
<property>
=A0 <name>hive.metastore.uris</name>=A0 <value>thrift://192.168.1= 0.22:9083</value>
</property>
<property>
=A0 <name>hive.metastore.warehouse.dir</n= ame>
=A0 <value>/user/hive/warehouse</value>
</prop= erty>
<property>
=A0 <name>hive.aux.jars.path</name>=A0 <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/zookeepe= r.jar</value>
</property>
<property>
=A0 <name>hive.zookeeper.quorum</name>=
=A0 <value>192.168.10.22:22= 81</value>
</property>
<property>
=A0 <name>hive.hwi.listen.host</name><= br>=A0 <value>0.0.0.0</value>
=A0 <description>This is= the host address the Hive Web Interface will listen on</description>=
</property>
<property>
=A0 <name>hive.hwi.listen.port</name><= br>=A0 <value>8888</value>
=A0 <description>This is th= e port the Hive Web Interface will listen on</description>
</pr= operty>
<property>
=A0 <name>hive.hwi.war.file</name>
= =A0 <value>lib/hive-hwi-0.7.1-cdh3u4.war</value>
=A0 <des= cription>This is the WAR file with the jsp content for Hive Web Interfac= e</description>
</property>
<property>
=A0 <name>hive.support.concurrency</name&= gt;
=A0 <value>true</value>
</property>
<property>
=A0 <name>hive.zookeeper.client.port</nam= e>
=A0 <value>2281</value>
</property>
<property>
=A0 <name>hive.lock.manager</name>
= =A0 <value>org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveL= ockManager</value>
</property>
</configuration>
=A0
hive> show tables;
FAILED: Error in semantic analysis: Lock mana= ger could not be initialized, check hive.lock.manager Check hive.zookeeper.= quorum and hive.zookeeper.client.port
OK
demo_hive
--047d7b6da16612e22a04e122481d--