Apache Hive Performance Tuning
Also available as:

Set up multiple HiveServer instances

If your cluster needs to accommodate more than 40 concurrent executing queries, you should create a new HiveServer instance. You can set up HiveServer instances, which can share the same metastore database for different purposes, such as ETL, interactive queries, 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.