Cloudera Enterprise 5.15.x | Other versions

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>
  Tip: To disable the HiveServer2 web UI, set the port to 0 or a negative number

Configuring the HiverServer2 Web UI in Cloudera Manager

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

  Note: By default, newly created CDH 5.7 (and higher) clusters have the HiveServer2 web UI enabled, and if using Kerberos, are configured for SPNEGO. Clusters upgraded from an earlier CDH version must have the UI enabled with the port property; other default values can be preserved in most cases.

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.
Page generated May 18, 2018.