Support Questions
Find answers, ask questions, and share your expertise

Hi all, can you please help me or guide me how to resolve this issue on my ambari hive view? When i go to Hive View i dont see any database even i create database via query nothing happen.

13 REPLIES 13

Mentor

Check your Hive is up and Application Timeline Server, it can't open because it can't communicate with either.

Mentor

Can you check this guide for all correct properties http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_hadoop-high-availability/content/ch_HA-Hi... you're getting zookeeper errors.

@Harold Allen Badilla

Share the stack trace from the error for detailed info.

Hi @Sindhu,

where can i find that "stack trace"?

Hi @Artem Ervits,

Thank you for your quick response. can you guide how to that? im new on this technology. i recently assign to this to explore. im following some guides but this error alert stops me .

12580-ambari-hive-view-error2.jpg

Mentor

Please share the error log in /var/log/hive for hiveserver2

i cant paste here my logs dont know why

Mentor

Attach as file or paste as answer, you're probably hitting limit

Cloudera Employee

hadoop.proxyuser.root.groups=*

hadoop.proxyuser.root.hosts=*

if ambari running as root put this configuration in custom core-site in HDFS config

su - hdfs
hadoop fs -mkdir /user/admin
hadoop fs -chown admin:hadoop /user/admin

https://docs.hortonworks.com/HDPDocuments/Ambari-2.1.0.0/bk_ambari_views_guide/content/_configuring_...

12611-hdfs-config.jpg

Hi @Hamid Zorgani

here's the config set on our HDFS

ihere what

@Artem Ervits do you see my logs?

Super Mentor

@Harold Allen Badilla

I do not see any log attached to this thread. How you attached it?

@Jay SenSharma

im just pasting it. too large to attach on this page.

2017-02-17 09:46:00,150 INFO [main-SendThread(XX002.XXDP.i4.internal.cloudapp.net:2181)]: zookeeper.ClientCnxn (ClientCnxn.java:logStartConnect(1019)) - Opening socket connection to server XX002.XXDP.i4.internal.cloudapp.net/10.94.11.37:2181. Will not attempt to authenticate using SASL (unknown error) 2017-02-17 09:46:00,151 WARN [main-SendThread(XX002.XXDP.i4.internal.cloudapp.net:2181)]: zookeeper.ClientCnxn (ClientCnxn.java:run(1146)) - Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717) at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361) at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1125) 2017-02-17 09:46:00,252 INFO [main-SendThread(XX001.XXDP.i4.internal.cloudapp.net:2181)]: zookeeper.ClientCnxn

; ;