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

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


Copy link to this message
-
[HIVE] Cannot perform a queries
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.