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