Using HiveServer2 Web UI in CDH

The HiveServer2 web UI provides access to Hive configuration settings, local logs, metrics, and information about active sessions and queries. The HiveServer2 web UI is enabled in newly created clusters running CDH 5.7 and higher, and those using Kerberos are configured for SPNEGO. Clusters upgraded from a previous CDH version must be configured to enable the web UI; see HiveServer2 Web UI Configuration.

Accessing the HiveServer2 Web UI

Access the HiveServer2 web UI by clicking the HiveServer2 Web UI link in Cloudera Manager or by pointing your browser to http://<host>:<port>/hiveserver2.jsp.

The following information is displayed:

  • Home (/hiveserver2.jsp): Active sessions, the latest Hive queries, and attributes of the Hive software.
  • Local Logs (/logs): The latest HiverServer2 logs.
  • Metrics Dump (/jmx): Real-time Java Management Extensions (JMX) metrics in JSON format.
  • Hive Configuration (/conf): The current HiveServer2 configuration in XML format.
  • Stack Trace (/stacks): A stack trace of all active threads.

HiveServer2 Web UI Configuration

For managed deployments, configure the HiveServer2 web UI in Cloudera Manager. See Configuring the HiverServer2 Web UI in Cloudera Manager.

For deployments not managed by Cloudera Manager, edit the configuration file /etc/hive/conf/hive-site.xml. To view the HiveServer2 web UI, go to http://<host>:<port>/hiveserver2.jsp.

Configurable Properties

HiveServer2 web UI properties, with their default values in Cloudera Hadoop, are:
hive.server2.webui.max.threads=50
hive.server2.webui.host=0.0.0.0
hive.server2.webui.port=10002
hive.server2.webui.use.ssl=false
hive.server2.webui.keystore.path=""
hive.server2.webui.keystore.password=""
hive.server2.webui.max.historic.queries=25
hive.server2.webui.use.spnego=false
hive.server2.webui.spnego.keytab=""
hive.server2.webui.spnego.principal=<dynamically sets special string, _HOST, as hive.server2.webui.host or host name>

Configuring the HiverServer2 Web UI in Cloudera Manager

Minimum Required Role: Configurator (also provided by Cluster Administrator, Full Administrator)

Configure the HiveServer2 web UI properties in Cloudera Manager on the Configuration tab.

  1. Go to the Hive service.
  2. Click the Configuration tab.
  3. Select Scope > HiveServer2.
  4. Search for "webui".
  5. Locate the properties you want to set and enter your preferred values.
  6. Click Save Changes to commit the changes.
  7. Select Actions > Restart and when done, click Close.
  8. Click HiveServer2 Web UI to view your changes.

You can use anAdvance Configuration Snippet to set properties that have no dedicated configuration field:

  1. On the Hive Configuration tab, search for "HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml".
  2. Click the plus icon to expand configurable attributes for each property.
  3. Enter values for Name, Value, and Description.
  4. Click the Final check box to ensure the value cannot be overwritten.
  5. Click Save Changes and select Actions > Restart > Close.
  6. Click HiveServer2 Web UI to view your changes.