Created 11-12-2018 11:01 AM
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
Created 11-12-2018 01:19 PM
@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
Created 11-12-2018 01:19 PM
@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
Created 11-12-2018 04:20 PM
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