Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Accessing hive database outside the cluster network ip address

avatar

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

1 ACCEPTED SOLUTION

avatar

@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

View solution in original post

2 REPLIES 2

avatar

@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

avatar

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