question HiveServer2 HA and HDP Views in Archives of Support Questions (Read Only)

HiveServer2 HA and HDP Views

albertozgz — Thu, 17 Aug 2017 01:25:42 GMT

HS2 load Balanced is supported by Hortonworks View?

HUE doesn't support it (Jira Hue 2738 )

chennuri_gouris — Thu, 17 Aug 2017 01:29:24 GMT

You can configure two separate hive views for two servers

albertozgz — Thu, 17 Aug 2017 03:23:51 GMT

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

chennuri_gouris — Thu, 17 Aug 2017 11:07:47 GMT

No views don't support that

SQLShaw — Thu, 17 Aug 2017 22:12:16 GMT

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.