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 Plain View
Hive >> mail # user >> [HIVE] Cannot perform a queries


+
Guillermo Alvarado 2013-08-22, 18:47
+
Guillermo Alvarado 2013-08-26, 16:08
Copy link to this message
-
Re: [HIVE] Cannot perform a queries
Can you share your hive-site.xml  and zookeeper log?
Unless you are using concurrency in hive, zookeeper is not needed.

I run hive without zookeeper.
On Mon, Aug 26, 2013 at 9:38 PM, Guillermo Alvarado <
[EMAIL PROTECTED]> wrote:

> Hi,
>
> Anybody can give me some help with this please?
>
> Thanks in advance,
> Regards.
>
>
> 2013/8/22 Guillermo Alvarado <[EMAIL PROTECTED]>
>
>> Hi everyone,
>>
>> I have a CDH4 cluster running In 4 nodes. I can perform queries in
>> Beeswax UI but If I try to perform the same query with the hive console it
>> is not possible.
>>
>> I launched the console in this way: hive -hiveconf
>> hive.root.logger=DEBUG,console and this is the output.
>>
>> ====>>
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client
>> environment:java.library.path=/opt/cloudera/parcels/CDH-4.3.0-1.cdh4.3.0.p0.22/lib/hadoop/lib/native
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client
>> environment:java.io.tmpdir=/tmp
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client
>> environment:java.compiler=<NA>
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:os.name
>> =Linux
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client
>> environment:os.arch=amd64
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client
>> environment:os.version=2.6.32-279.el6.x86_64
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:user.name
>> =root
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client
>> environment:user.home=/root
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Client environment:user.dir=/
>> 13/08/22 13:44:21 INFO zookeeper.ZooKeeper: Initiating client connection,
>> connectString=datlas-cloudera-m01:2181 sessionTimeout=600000
>> watcher=org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockManager$DummyWatcher@357c7988
>> 13/08/22 13:44:21 DEBUG zookeeper.ClientCnxn:
>> zookeeper.disableAutoWatchReset is false
>> 13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Opening socket connection to
>> server datlas-cloudera-m01/10.5.96.195:2181. Will not attempt to
>> authenticate using SASL (No se puede localizar una configuración de inicio
>> de sesión)
>> 13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Socket connection
>> established to datlas-cloudera-m01/10.5.96.195:2181, initiating session
>> 13/08/22 13:44:21 DEBUG zookeeper.ClientCnxn: Session establishment
>> request sent on datlas-cloudera-m01/10.5.96.195:2181
>> 13/08/22 13:44:21 INFO zookeeper.ClientCnxn: Unable to read additional
>> data from server sessionid 0x0, likely server has closed socket, closing
>> socket connection and attempting reconnect
>> Interrupting... Be patient, this might take some time.
>> 13/08/22 13:44:21 INFO CliDriver: Interrupting... Be patient, this might
>> take some time.
>> 13/08/22 13:44:21 INFO ql.Driver: <PERFLOG method=acquireReadWriteLocks>
>> 13/08/22 13:44:22 INFO zookeeper.ClientCnxn: Opening socket connection to
>> server datlas-cloudera-m01/10.5.96.195:2181. Will not attempt to
>> authenticate using SASL (No se puede localizar una configuración de inicio
>> de sesión)
>> 13/08/22 13:44:22 INFO zookeeper.ClientCnxn: Socket connection
>> established to datlas-cloudera-m01/10.5.96.195:2181, initiating session
>> 13/08/22 13:44:22 DEBUG zookeeper.ClientCnxn: Session establishment
>> request sent on datlas-cloudera-m01/10.5.96.195:2181
>> 13/08/22 13:44:22 INFO zookeeper.ClientCnxn: Unable to read additional
>> data from server sessionid 0x0, likely server has closed socket, closing
>> socket connection and attempting reconnect
>>
>> =====>>
>> Also, when I see the status of the services with the cloudera manager UI
>> I see a Bad Health in Zookeper and HBase. I restarted a lot of times
>> Zookeper but it is in the same status.
>>
>> Why I can perform queries with Beeswax UI and not with Hive console? And
>> how can I solve this problem?
>>
>> BTW, if I type SHOW TABLES, I get the result, but a SELECT does not work
>>
>>
>> I will apreciate very much your help,
>> Thanks in advance.
Nitin Pawar
+
Guillermo Alvarado 2013-08-26, 20:01
+
Nitin Pawar 2013-08-27, 04:12
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