Set up multiple HiveServer Interactives for high availability
After enabling interactive query, you can optionally set up additional HiveServer Interactive instances for high-availablilty. One instance operates in active mode, the other in passive (standby) mode. The passive instance serves as a backup and takes over if the active instance goes down.
Add HiveServer2 Interactivefrom Actions after completing the LLAP setup. If you add an additional HiveServer Interactive instance in this way, it will not operate in active/passive mode. If you make this mistake, remove HSI instances, keeping HS2 and HMS, and then re-add HSI in the following way:
In Select HiveServer Interactive Host, after selecting one HiveServer2
Interactive host, click + to add another.
- Accept the default server to host the additional HiveServer Interactive, or from the drop-down, select a different host.
- Optionally, repeat these steps to add additional HiveServer Interactives.