How to Connect to Hadoop Cloudera Hive Cluster

If you encounter the following Cloudera connection errors, the following steps to restart all Cloudera services will most likely resolve issue.

This article explains how to address the following connection errors shown below that you may encounter.

To resolve connection errors above, user should try to restart all Cloudera services using the Cloudera Manager.

How To access Cloudera Manager

1. On your Windows desktop, click the Cloudera.RDP icon to connect to Hadoop Cloudera remote machine.

2. On the Cloudera desktop, click on Terminal icon.

a.      At the cloudera@quickstart prompt, type "sudo /home/cloudera/cloudera-manager --force --express" (without quotes) and hit ENTER.  This can take a while (up to 10 minutes) to complete since the CDH services need to be shutdown. You should see the following if done correctly.  

                                                    i.     Please note the logon credentials for the remote Cloudera machine

1.      username = cloudera; password = cloudera

3. Minimize the Cloudera RDP connection window.

4. On you windows desktop, click on Mozilla Firefox browser icon.   Then, click on the Cloudera Manager favorite as shown in the screenshot below.

5. Click I agree when an Information Assurance Policy window appears.

1.      6. At the logon window, make sure username = cloudera and password = cloudera before clicking Login.

1.      7. In the Cloudera Manager web page, click the drop down menu tab next to Cloudera QuickStart option and click the Restart option.

1.        8. Click Restart again to confirm restart Cloudera cluster when prompted.

1.        9. The restart can take up to 10 minutes so user must be patient.   Once completed, user should see the following message that “All services successfully started.”

10. On you windows desktop, minimize the Mozilla Firefox browser Cloudera Manager window and double click the Cloudera RDP connection window to maximize window.

11. If the Terminal window is open, proceed to next step.  Otherwise, click on the Terminal icon on the Cloudera desktop.

12. At the cloudera@quickstart command prompt, type hadoop fs –ls / and click ENTER.  User should see the following response.

13. To test connection to hive, type hive and click ENTER.  User should see the following response.