Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Accessing hive database outside the cluster network ip address

Solved Go to solution

Accessing hive database outside the cluster network ip address

New Contributor

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

Accepted Solutions
Highlighted

Re: Accessing hive database outside the cluster network ip address

@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

2 REPLIES 2
Highlighted

Re: Accessing hive database outside the cluster network ip address

@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

New Contributor

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