@mungeol heo By any change have you configured any "config group" and assigned these different hosts to it? Also the seconds logging config looks good. On the first hiveserver2 instance do you have the following path existing with proper permission? # ls -l /etc/hive/2.6.0.3-8/0/conf.server/hive-log4j.properties -rw------- 1 hive hadoop 3091 May 15 13:33 /etc/hive/2.6.0.3-8/0/conf.server/hive-log4j.properties . Also do you have any Environment Global Variable set related to hive conf dir on these hosts? As in the first host the setting of log4j seems to be loading from insdie the jar , so suspecting that some explicitly set classpath setting might be done in some of the script/global environment level so that the JAR may be coming first in the CLASSPATH before the "conf" directory. . ... View more

@Mohd Azhar You are getting the error showing the following message: TezUncheckedException: Invalid configuration of tez jars, tez.lib.uris is not defined So can you please check and share the "tez.lib.uris" property to the above file location under Ambari > Hive configs > (custom hive-site) is it pointing to correct tar file? Example: tez.lib.uris = /hdp/apps/${hdp.version}/tez/tez.tar.gz - Also please check if the path for the "tez-site.xml" is added in the "webhcat-site.xml" in Hive configs as following or not: templeton.libjars=/usr/hdp/${hdp.version}/zookeeper/zookeeper.jar,/usr/hdp/${hdp.version}/hive/lib/hive-common.jar/,/etc/tez/conf/tez-site.xml . ... View more

@jack jack Is there any specific reason that you want to use "Phoenix" and not via RestAPI? You can refer to the following article to see if this is what you are looking out for: https://community.hortonworks.com/content/kbentry/71206/using-phoenix-sqlline-utility-to-browse-ambari-met.html Example: /usr/hdp/2.5.0.0-1245/phoenix/bin/sqlline.py c6403.ambari.apache.org:61181:/ams-hbase-unsecure . ... View more

@Mahesh Jadhav Are you looking out for this: https://community.hortonworks.com/questions/4408/is-there-any-way-to-reset-ranger-admin-ui-password.html . Additionally if you have configured Ranger HA then you also might want to take a look at the following article: https://community.hortonworks.com/articles/69842/ranger-ha-fails-if-admin-password-is-changed-to-no.html . Doc: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_security/content/updating_ranger_admin_passwords.html ... View more

@Mohammad Shamim If there are many DataNodes then one of the DN will not cause much harm, as there is Replication Factor so the data will be having replicas on other DNs. However it will be good to investigate why the DN went down. So looking at the DN log, Garbage Collection log can help. Sometimes JVM crash also can cause DN to go down. Immediate admin task will be to attempt to bring the DataNode. Then admin can start looking at the DN log, Garbage Collection to see why the DN went down. (in case of DataNode jvm crash the "hs_err_pid" file is generated usually, that can be reviewed). . From Ambari 2.5 onwards there is a new feature called as "Service Auto Start" then you might want to look at: https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.1.0/bk_ambari-operations/content/ch07s04.html Enabling auto-start for a service causes the ambari-agent to attempt re-starting service components in a stopped state without manual effort by a user. . ... View more