Apache Hive Performance Tuning
Also available as:

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.

  • You installed Hive using Ambari and Hive is running.
  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.