Apache Hive Performance Tuning
Also available as:

Use HiveServer Interactive UI

You can access the HiveServer Interactive UI in Ambari to monitor and display heap, system, and cache metrics of each Hive LLAP node.

  • You installed Hive using Ambari and Hive is running.
  • You enabled LLAP and started HiveServer Interactive.

In this task you open the HiveServer Interactive UI and view executing queries in real time or a recent history of queries. From the UI, you can also access running LLAP daemons.

  1. In Ambari, select Services > Hive > Summaryand in Quick Links, click HiveServer Interactive UI.

    The HiveServer Interactive UI shows LLAP running on two daemons (instances).

  2. Click Local Logs.
    A list of HiveServer Interactive logs appears.
  3. Click hiveserver2Interactive.log.
    The logged data from /var/log/hive/hiveserver2Interactive, which you can use for troubleshooting HiveServer Interactive problems, appears.
  4. Click hive-server2-interactive.err.
    The logged data about queries, which includes query and task execution summaries, appears.