HiveServer2 HA and HDP Views

[#1]

HS2 load Balanced is supported by Hortonworks View?

HUE doesn't support it (Jira Hue 2738 )

[#2]

You can configure two separate hive views for two servers

[#3]

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

[#4]

No views don't support that

[#5 · Accepted solution]

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