question Accessing hive database outside the cluster network ip address in Archives of Support Questions (Read Only)

Accessing hive database outside the cluster network ip address

sunil_prasath_e — Mon, 12 Nov 2018 19:01:17 GMT

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

Re: Accessing hive database outside the cluster network ip address

falbani — Mon, 12 Nov 2018 21:19:49 GMT

@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

Re: Accessing hive database outside the cluster network ip address

sunil_prasath_e — Tue, 13 Nov 2018 00:20:49 GMT

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