Connection problems

Symptoms

Common Causes

Common Resolutions

Hostname does not resolve.

  • No hostname has been specified.

  • Hostname/IP Address is incorrect.

  • Hostname is not resolving properly in the DNS.

  • Verify that the Hostname/IP address is correct.

  • Check the DNS to make sure the Hostname is resolving properly.

Port number does not resolve.

  • Port number is incorrect.

  • Port number is not numeric.

  • The port number is not necessary for HA clusters.

  • No port number has been specified.

  • Verify that the port number is correct.

  • Determine whether your cluster has been enabled for high availability (HA). If it has, then you do not need a port number. Clear the port number and retest the connection.

Cannot connect to the cluster.

  • Firewall is a barrier to connecting.

  • Other networking issues are occurring.

  • A *-site.xml file is invalid.

  • The address or port number information is incorrect for the cluster or service you are trying to connect.

  • Verify that a firewall is not impeding the connection and there are no other network issues.

  • Verify that all *-site.xml files are well-formed, valid XML.

  • Verify that the addresses and port numbers for the cluster and services are correct.

Windows failure message: “java.io.FileNotFoundException: HADOOP_HOME and hadoop.home.dir are unset

  • A configuration setting is required. Windows cannot locate the %HADOOP_HOME%\bin\winutils.exe file and the Hadoop_Home directory is not set.

Please follow the instructions at https://cwiki.apache.org/confluence/display/HADOOP2/WindowsProblems and set the environment variable %HADOOP_HOME% to point to the directory path containing WINUTILS.EXE.

Cannot access a Hive database (Secured Clusters Only).

  • To access Hive, you need to set two database connection parameters using the PDI client.

  1. Open the hive-site.xml file on the Hive server host. Note the values for the kerberos.principal and the sasl.qop parameters, then close the file.

  2. Start the PDI client and open the Database Connection window.

  3. Click Options, and add the sasl.qop and principal parameters. Set them to the same values as they are in the hive-site.xml file. Save and close the file.

Last updated

Was this helpful?