I think this was due to non runnning metstore service from hive.   You should run command "hive --service metastore & " first and then start hive console.  ... View more

@jsensharma Thank you for your answer. I am facing similar issue with Ambari 2.7.0, Mysql 5.7.29. I am unable to get into admin account even once and on click of Login it just hangs and says 'Unable to connect to Ambari Server. Confirm Ambari Server is running and you can reach Ambari Server from this machine.' after some seconds.'   I even posted details here: https://stackoverflow.com/q/60743259/7051479   Could you please help me out on this. ... View more

I will just try that ... View more

@darkz yu Yes, that sounds right. Sorry I missed the step which would have triggered the modification of the '/etc/hadoop/conf/hadoop-metrics2.properties' file. So, is your problem fixed now? ... View more

@Jay Kumar SenSharma Referring to the PUT command used for triggering the alert manually, Is it possible to pass some parameters/custom information to the script which gets trigged by the alert ? If yes, is it via headers OR body of the PUT request ? Thanks. ... View more

set 'hive.query.name' ... View more

I had find that on host hadoop1.xxx which the hive metastore running ,exists the /tmp/hive/ and /tmp/hive/hive.log and own to hive.hadoop. So I think there may be something other couse the problem. And I run the following command using ambari user: export HIVE_CONF_DIR='/usr/hdp/current/hive-metastore/conf/conf.server' hive --hiveconf hive.metastore.uris=thrift://hadoop1.xxx: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;' --hiveconf hive.root.logger=DEBUG,console It shows me every think is OK... ... View more

@Jay SenSharma I try it and it works fine. It should be: curl -u ${ambari_user_name}:${ambari_user_pass} -H "X-Requested-By: ambari"-d '{"RequestInfo":{"context":"Starting Flume agent","flume_handler":"agent","operation_level": {"level":"HOST_COMPONENT","cluster_name":"${CLUSTER_NAME}","service_name":"FLUME","host_name":"${hostname_of_new_flume_agent}"}},"Body":{"HostRoles":{"state":"STARTED"}}}'-X PUT "http://${AMBARI_HOST}:8080/api/v1/clusters/${CLUSTER_NAME}/hosts/${hostname_of_new_flume_agent}/host_components/FLUME_HANDLER" And now if I want do add a new agent ,I must change the configure on the ambari web ui ,then call the ambari server api above. Why not make it more easy?? ... View more

I had install new openjdk 1.8 and there is the old 1.6 version on the same version I use /usr/sbin/alternatives --config java changed the java version, and then use java -version,it shows me the openjdk version is 1.8 but I found /usr/lib/jvm/ linked to /etc/alternatives/java_sdk and still linked to /usr/lib/jvm/java-1.6.0-openjdk.x86_64 So I think nothing changed. I just set JAVA_HOME to /usr/lib/jvm/java ，and want not to change the java home path after each jdk upgrade. So I don't know why the /etc/alternatives/java_sdk link not change. ... View more