@Sami Ahmad Your Compilation Issue is resolved. For which the thread was opened. Regarding Connection refused, the troubleshooting is completely different. Please open separate HCC thread. And in Parallel check if the 10000 port is opened by the hive process on the mentioned host "localhost" or not? Or check the hostname is pointing to correct hive instance? # netstat -tnlpa | grep 10000 . Also check if there is any firewall issue in accessing the hive 10000 port if hive is running on remote host? # telnet localhost 1000 # telnet $HIVE_HOSTNAME 10000 ... View more

@Sami Ahmad For different issues , Better to open separate HCC thread. That way we can manage the threads properly and users can quickly find one issue one resolution. ... View more

@Sami Ahmad You have not set the CLASSPATH properly to inclide the required HIve and Hadoop JARs to it. If you really want to run a simple hive client code then please refer to the following Example where i developed a very simple Java Based Hive Client using Maven: https://github.com/jaysensharma/MiddlewareMagicDemos/tree/master/HDP_Ambari/Hive/HiveJavaClient . ... View more

@Sami Ahmad Please replace the : public static void main(String[] args) throws SQLException { With the following: public static void main(String[] args) throws Exception { . OR as an alternative approach either use "try{ } catch(ClassNotFoundException cnef)". OR try public static void main(String[] args) throws SQLException, ClassNotFoundException { . ... View more

@Daniel Müller For more informations please refer to: https://docs.hortonworks.com/HDPDocuments/Ambari-2.4.0.0/bk_ambari-reference/content/how_to_customize_the_name_of_a_host.html hostname_script=/var/lib/ambari-agent/hostname.sh public_hostname_script=/var/lib/ambari-agent/public_hostname.sh . ... View more

@Daniel Müller Yes, Deleting unwanted hosts using Ambari API is also correct option. The DB queries just cleans all the unwanted information's of old hostnames from the DB completely. But both options are valid/good. . Regarding changing the agent host name permanently. ** Permanently fix the public hostname: (Recommended) 1. Create a file with name : "/var/lib/ambari-agent/public_hostname.sh" then in that file add the following line: #!/bin/sh echo `hostname -f` 2. Make sure that the file "/var/lib/ambari-agent/public_hostname.sh" has proper execute permission. Example: chmod 755 "/var/lib/ambari-agent/public_hostname.sh" 3. On every ambari-agent host edit the file "/etc/ambari-agent/conf/ambari-agent.ini" and in the [agent] section add the following line: ## Added following to customize the public hostname public_hostname_script=/var/lib/ambari-agent/public_hostname.sh NOTE: Users can also use the property "hostname_script" to customize the internal hostname. 3. Make sure that the changes are pushed to all the hosts present in the ambari cluster. 4. Now restart the agents. ambari-agent restart . ... View more

@Gavin Duffy I see that the URL is "https" here: https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.40.zip So you should also set the"https_proxy" as well. export http_proxy=http://YOURPOROXY:PORT export https_proxy=https://YOURPOROXY:PORT . ... View more