Support Questions
Find answers, ask questions, and share your expertise

HiveServer2 HA and HDP Views

Explorer

HS2 load Balanced is supported by Hortonworks View?

HUE doesn't support it (Jira Hue 2738 )

1 ACCEPTED SOLUTION

Accepted Solutions

@Alberto Ramon

You can setup multiple H2 instances and then create a DNS with their IPs. You would then point the Hive View to that DNS. See this related article on how to load balance H2. https://community.hortonworks.com/questions/110277/load-balancing-hiveserver2-over-knox.html. This is a supported configuration.

View solution in original post

4 REPLIES 4

Expert Contributor

You can configure two separate hive views for two servers

Explorer

yes, but the target is auto load balance of all user's queries and HS2

I don't know if Views admit this syntax in connections:

jdbc:hive2://<zookeeperList>;serviceDiscoveryMode=zooKeeper; zooKeeperNamespace=hiveserver2

Expert Contributor

No views don't support that

@Alberto Ramon

You can setup multiple H2 instances and then create a DNS with their IPs. You would then point the Hive View to that DNS. See this related article on how to load balance H2. https://community.hortonworks.com/questions/110277/load-balancing-hiveserver2-over-knox.html. This is a supported configuration.

View solution in original post