Problem connecting Visual Studio HDInsight Emulator to Hive on a YARN cluster

Question

I want to use Visual Studio to query from hive which is installed on a YARN cluster under Centos7 X64. The Cluster has a master node and 4 worker nodes. I already succeeded the connection to WebHDFS and SSH but can not connect to HiveServer2. All services are up and running including HDFS, YARN and HiveServer2.

I've set port 10000 for HiveServer2 in hive-site.xml and the Web UI is being shown on port 10002. I installed hive ODBC driver and configured it. It successfully connects to my HiveServer2 on port 10000.

The HDInsight Emulator just shows 'Failed to open connection. Please check your connection string. See inner exception for failure details' I tried 10000, 10001 and 10002 port numbers but still the problem persists.

Answer 1

Welcome to Stackoverflow!

Steps to connect HDInsight emulator using Visual Studio:

1. Open Visual Studio, select View, and then select Server Explorer.
2. From Server Explorer, right-click the HDInsight entry, and then select Connect to HDInsight Emulator.

3. From the Connect to HDInsight Emulator dialog box, enter the password that you configured for Ambari. Select Next to continue.

4. Use the Password field to enter the password you configured for the root account. Leave the other fields at the default value. Select Next to continue.

5. Wait for validation of the services to finish. In some cases, validation may fail and prompt you to update the configuration. If validation fails, select Update, and wait for the configuration and verification for the service to finish.

6. After validation has finished, select Finish to complete configuration.

For more details, refer "How to use HDInsight emulator using Visual Studio".

Hope this helps.