Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Using VisualStudio to connect to HDP 2.6

Highlighted

Using VisualStudio to connect to HDP 2.6

New Contributor

I'm trying to connect Visual Studio HDInsights Emulator to an Hortonworks 2.6 HDP Cluster. (3 master servers, and 3 data nodes) but every time i try to connect, i have issues wiht HiveServer2 and WebHDFS. any help would be appreciated... i'm trying to find a good GUI for writting HIVE quries outside of the hive view since it was discontinued in future distros.

here's the writeup i'm using: https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-hadoop-emulator-visual-studio

i'm using visual studio 2017, hdp 2.6, and i've got my endpoints setup as:

WebHCat: http://hdpmn03.mydomain.com:50111 (this is the node my hive / webhcat resides on)

HiveServer2: http://hdpmn03.mydomain.com:10000 (this is the node my hive / webhcat resides on, also did a portscan and some googling and found that usually it's port 10000, not the default v.s. trys to set it to 10001)

WebHDFS: http://hdpmn01.mydomain.com:50070 (this is my namenode, i post files via curl all the time so i know this is correct)

SSH: http://hdpmn01.mydomain.com:22 (centos7 box, i assume this is right, i get creen when i hit next)

Yarn Timeline: http://hdpmn01.mydomain.com:8188 (yarn timeline is on this box)

User: root

Pw: ######

when i hit next,

WebHcat service is connected successfully.

Failed to connect to HiveServer2 - Error Detail :Failed to open connection. Please check your connection string. See inner exception for failure details. but i have no way of seeing what the error is (unless you guys have any ideas). i have a pause sign WebHDFS. could be connected but needs config change (if i hit update, it changes to error 403 forbidden)

SSH Service is connected scucessfully.

any help in getting V.S. connected so i can play with some quries and what-not would be super helpful! thanks!

2 REPLIES 2

Re: Using VisualStudio to connect to HDP 2.6

New Contributor

Hi Albert, I've the same problem.

I hope that someone answers at this question.

I think that we must change same parameters in the hortonworks sandbox, but i don't know where.

Thanks

Re: Using VisualStudio to connect to HDP 2.6

Community Manager

@albert kohl and @max max You will be much more likely to get a helpful response if you post your question in the Microsoft Azure Community. Good luck!

Bill Brooks, Community Manager
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Don't have an account?
Coming from Hortonworks? Activate your account here