Restarting agent removed the hearbeat lost Error - Thank you. Alert still persists though. Here are the outputs: sandbox.hortonworks.com:10000 also gave the same Error. You said these ports must be already in use(I tried netstat -nl | grep 10000 and for 9083 port - It showed tcp LISTEN ) so what can I do to overcome this issue. Thanking you in advance! @Manish Gupta ... View more

Thank you @Ed Gleeck 1. I tried the command 'ambari-server restart' which resulted in heartbeat lost on ambari UI. I was logged in as Admin. 2. I restarted the ambari server from command line as a root user: which showed it was successful. 3. I had tried restarting all services of hive before doing this but that didnot clear the alert. Please let me know if you need more information on the error. Thanks again! ... View more

Thank you @vpoornalingam I have added the alert statement above. Hive and beeline is not working in command line. Attaching that error below: Hive Error: It was hung after this statement.. nothing appeared after this. Beeline Error: ... View more

Metastore on sandbox.hortonworks.com failed (Execution of 'ambari-sudo.sh su ambari-qa -l -s /bin/bash -c 'export PATH='"'"'/usr/sbin:/sbin:/usr/lib/ambari-server/*:/sbin:/usr/sbin:/bin:/usr/bin:/var/lib/ambari-agent:/bin/:/usr/bin/:/usr/sbin/:/usr/hdp/current/hive-metastore/bin'"'"' ; export HIVE_CONF_DIR='"'"'/usr/hdp/current/hive-metastore/conf/conf.server'"'"' ; hive --hiveconf hive.metastore.uris=thrift://sandbox.hortonworks.com:9083 --hiveconf hive.metastore.client.connect.retry.delay=1 --hiveconf hive.metastore.failure.retries=1 --hiveconf hive.metastore.connect.retries=1 --hiveconf hive.metastore.client.socket.timeout=14 --hiveconf hive.execution.engine=mr -e '"'"'show databases;'"'"''' was killed due timeout after 30 seconds) ... View more