https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131039#M55840 <P>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.</P> Wed, 01 Mar 2017 11:30:49 GMT dsun 2017-03-01T11:30:49Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131037#M55838 <P>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.</P> Wed, 01 Mar 2017 04:03:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131037#M55838 dsun 2017-03-01T04:03:23Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131038#M55839 <P>I am not familiar with sas but for most BI tools they require the hostname for your hiveserver 2 and port which is generally </P><P>10010 or for llap 10500.</P> Wed, 01 Mar 2017 11:16:15 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131038#M55839 sunile_manjee 2017-03-01T11:16:15Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131039#M55840 <P>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.</P> Wed, 01 Mar 2017 11:30:49 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131039#M55840 dsun 2017-03-01T11:30:49Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131040#M55841 <P>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.</P> Wed, 01 Mar 2017 11:37:09 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-connect-a-BI-tool-to-a-HiveServer2-instance-running/m-p/131040#M55841 sunile_manjee 2017-03-01T11:37:09Z