Set up multiple HiveServer instances

You can set up HiveServer instances, which can share the same metastore database for different purposes, such as ETL, running multiple applications using different settings, or load-balancing using ZooKeeper.

1. In Ambari, select Hosts.

   

2. Click the name of the host node where you want to create the HiveServer instance.
3. In Summary, in Components, click Add, and select HiveServer.

   

   Do not add HiveServer Interactives for high availability using this procedure.