How to connect a BI tool to a HiveServer2 instance running on a HDP 2.5 SandBox?

[#1]

How to connect a BI tool, SAS for instance, to a HiveServer2 instance running on a HDP 2.5 SandBox? I assume it involves IP parsing? Thanks.

[#2 · Accepted solution]

I am not familiar with sas but for most BI tools they require the hostname for your hiveserver 2 and port which is generally

10010 or for llap 10500.

[#3]

Thanks Sunile, I am familiar with all the ports. The issue is the BI tool, in this case SAS, can ping the local Windows machine, but not the SandBox running on it. I would assume we will need to make some changes to the hosts file so the SandBox IP can be exposed.

[#4]

oh yes. you need to use ip address of the sandbox. the host file does not need to be updated unless you plan to use a dns (ie sandbox.hortonworks.com) to it. for your test use the sandbox ip. i assume all this exist on same box? if not then your windows machine needs to be able to communicate to the sandbox. open up firewalls for ip com.