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.

[#1]

[#2]

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

[#3]

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.

[#4]

@Harold Allen Badilla

Share the stack trace from the error for detailed info.

[#5]

Hi @Sindhu,

where can i find that "stack trace"?

[#6]

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 .

[#7]

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

[#8]

i cant paste here my logs dont know why

[#9]

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

[#10]

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

[#11]

Hi @Hamid Zorgani

here's the config set on our HDFS

ihere what

[#12]

@Artem Ervits do you see my logs?

[#13]

@Harold Allen Badilla

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

[#14]

@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