Accessing hive database outside the cluster network ip address

[#1]

Hi All,

We need to connect our hive database from a remote server (via ODBC - to connect with powerBI server) ,which is outside of our cluster location.

I have opened a firewall request to our hive head node and the port 10000 .

Is that enough to access hive database , or do we need to open it for all the data nodes.

Folks , kindly share your experience ASAP.

Regards,

Sunil

[#2 · Accepted solution]

@sunilprasath elangovan Yes that should be enough, however you may want to configure HS2 with http protocol instead of binary. And for this use-case you may also want to evaluate adding Knox service to the cluster.

HTH

[#3]

Thanks for you response @Felix Albani , do you have any document how to create Knox gateway for opening hive database to external server. Our cluster is HDP 3.0 which is configured with kerberos