Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> [HIVE] Cannot perform a queries


Copy link to this message
-
Re: [HIVE] Cannot perform a queries
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB