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

Switch to Plain View
Hive, mail # user - [HIVE] Cannot perform a queries


+
Guillermo Alvarado 2013-08-22, 18:47
+
Guillermo Alvarado 2013-08-26, 16:08
+
Nitin Pawar 2013-08-26, 16:41
+
Guillermo Alvarado 2013-08-26, 20:01
Copy link to this message
-
Re: [HIVE] Cannot perform a queries
Nitin Pawar 2013-08-27, 04:12
Not sure, why your zookeeper has reached max connection and then its
blocking hive to connect anymore.

Can you remove
==<property>
    <name>hive.zookeeper.quorum</name>
    <value>datlas-cloudera-m01</value>
  </property>
  <property>
    <name>hive.zookeeper.client.port</name>
    <value>2181</value>
</property>
===and give it a try.

On Tue, Aug 27, 2013 at 1:31 AM, Guillermo Alvarado <
[EMAIL PROTECTED]> wrote:

> Hi Nitin,
>
> I apreciate your help,
>
> This is my hive-site.xml:
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <!--Autogenerated by Cloudera CM on 2013-06-26T17:55:39.126Z-->
> <configuration>
>   <property>
>     <name>hive.metastore.local</name>
>     <value>false</value>
>   </property>
>   <property>
>     <name>hive.metastore.uris</name>
>     <value>thrift://datlas-cloudera-m01:9083</value>
>   </property>
>   <property>
>     <name>hive.metastore.warehouse.dir</name>
>     <value>/user/hive/warehouse</value>
>   </property>
>   <property>
>     <name>hive.warehouse.subdir.inherit.perms</name>
>     <value>true</value>
>   </property>
>   <property>
>     <name>mapred.reduce.tasks</name>
>     <value>-1</value>
>   </property>
>   <property>
>     <name>hive.exec.reducers.bytes.per.reducer</name>
>     <value>1073741824</value>
>   </property>
>   <property>
>     <name>hive.exec.reducers.max</name>
>     <value>999</value>
>   </property>
>   <property>
>     <name>hive.metastore.execute.setugi</name>
>     <value>true</value>
>   </property>
>   <property>
>     <name>hive.support.concurrency</name>
>     <value>true</value>
>   </property>
>   <property>
>     <name>hive.zookeeper.quorum</name>
>     <value>datlas-cloudera-m01</value>
>   </property>
>   <property>
>     <name>hive.zookeeper.client.port</name>
>     <value>2181</value>
>   </property>
>   <property>
>     <name>hive.aux.jars.path</name>
>     <value>file:/etc/hive/hive-serdes-1.0-SNAPSHOT.jar</value>
>   </property>
>   <property>
>     <name>hive.server2.authentication</name>
>     <value>NOSASL</value>
>   </property>
> </configuration>
>
>
> And this is the Zookeeper log:
>
> 2013-08-26 14:59:05,803 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:07,653 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:09,364 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:11,336 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:12,950 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:14,523 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:16,547 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:17,884 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:19,243 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:21,106 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:23,156 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:24,479 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:25,372 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
> 2013-08-26 14:59:25,779 WARN
> org.apache.zookeeper.server.NIOServerCnxnFactory: Too many connections from
> /10.5.96.195 - max is 60
Nitin Pawar