Support Questions

Find answers, ask questions, and share your expertise

HiveServer2 HA and HDP Views

avatar
Explorer

HS2 load Balanced is supported by Hortonworks View?

HUE doesn't support it (Jira Hue 2738 )

1 ACCEPTED SOLUTION

avatar

@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

avatar
Super Collaborator

You can configure two separate hive views for two servers

avatar
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

avatar
Super Collaborator

No views don't support that

avatar

@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.