@Anurag Mishra Ambari does not maintain this information. Which means thewre is no database/table/column where we can see the information about last logged in Time for a user. Hence there is no API available for the same. However you can parse the "ambari-audit.log" to extract similar kind of info # grep 'User login' /var/log/ambari-server/ambari-audit.log . ... View more

@Mahender S This post looks like a Duplicate of : https://community.hortonworks.com/questions/198223/how-to-address-ambari-alert-namenode-heap-usage-da.html?childToView=198230#answer-198230 Can we close one thread and continue of the existing HCC thread. ... View more

@Michael Bronson As the AMS collector seems to be running it should collect and show the data however we will need to check if AMS collector has the data or not? So in order to check that we will need to capture the following informations: 1. Need to make an API call to the AMS collector in order to list down the number & names of metrics that it is collecting? and from which hosts. The following URLs will give us JSON output . Can you please share the same here. http://<ams-host>:6188/ws/v1/timeline/metrics/metadata http://<ams-host>:6188/ws/v1/timeline/metrics/hosts 2. Need to check the Binaries of ambari collector and sink (so that we can see if it is same as ambari ersion) # rpm -qa | grep ambari 3. Can you please check if the metrics-monitor logs shows any kind of connectivity error while connecting to AMS collector? # /var/log/ambari-metrics-monitor/ambari-metrics-monitor.out 4. Do we see if the hostname resolution if file and correctly defined inside the "/etc/ambari-metrics-monitor/conf/metric_monitor.ini" file 5. Please check if the AMS collector log shows any error? ... View more

@Manish Roy If oyu have enough system resources like RAM/CPUs/DiskSpace then there should be no issues you can install Nifi & Kafka on same host as well. For example you can check the HDF Sandbox where both are installed on the same single host. https://hortonworks.com/tutorial/getting-started-with-hdf-sandbox/ Additionally], the following two articles can help in tuning Nifi + Kafka https://community.hortonworks.com/articles/80813/kafka-best-practices-1.html https://community.hortonworks.com/articles/7882/hdfnifi-best-practices-for-setting-up-a-high-perfo.html ... View more

@panitta suksaran As we see the error, Where it looks like you have not setup MySQL server for Hive properly. Please see: https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.0/bk_ambari-administration/content/using_hive_with_mysql.html raise Fail("Failed to download file from {0} due to HTTP error: {1}".format(self.url, str(ex))) resource_management.core.exceptions.Fail: Failed to download file from http://xxxxxx:8080/resources//mysql-connector-java.jar due to HTTP error: HTTP Error 404 So please make sure that you have already done the following steps? On the Ambari Server Host. # yum install mysql-connection-java -y (OR) if you are downloading the mysql-connector-java JAR from some tar.gz archive then please make sure to check the following locations and create the symlinks something like following to point to your jar. . Then you should find some symlink as following: Example: # ls -l /usr/share/java/mysql-connector-java.jar lrwxrwxrwx 1 root root 31 Apr 19 2017 /usr/share/java/mysql-connector-java.jar -> mysql-connector-java-5.1.17.jar https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.0/bk_ambari-administration/content/using_hive_with_mysql.html So now ambari knows how to find this jar. The JAR can be found here after # ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar # ls -l /var/lib/ambari-server/resources/mysql-connector-java.jar -rw-r--r-- 1 root root 819803 Sep 28 19:52 /var/lib/ambari-server/resources/mysql-connector-java.jar Reference HCC Thread: https://community.hortonworks.com/questions/186090/mysql-connector-javajar-due-to-http-error-http-err.html . ... View more

@Jakub Igla While setting up knox for ambari we must define both the following roled inside the knos topology: <service> <role>AMBARI</role> <url>http://$AMBARI_HOST:8080</url> </service> <service> <role>AMBARIUI</role> <url>http://$AMBARI_HOST:8080</url> </service> . After making the above changes please try to restart the knox and then try again. ... View more

@Basil Paul Looks like you might have Enabled firewall on the NameNode host "env40-node1" Can you please check if the firewall (iptables) is stopped on the NameNode host or not? # service iptables stop (CentOS 6) # systemctl stop firewalld (CentOS 7) Once you have confirmed that the firewall (iptables) is not running on NameNode host then from the "" try to connect to NameNode using on port 8020 using netcat or telnet to verify the connectivity. Or the host name resolution. [root@env7-head-proxy4 ~]# nc -v 192.168.150.95 8020 (OR) [root@env7-head-proxy4 ~]# telnet 192.168.150.95 8020 . Also please check if the env7 host is able to resolve the hostname of NameNode or not? ... View more