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
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