Hive starting with version 2.0, configuring and using the Web UI Management page for Hiveserver2

About the configuration and use of Hiveserver2 Web UI Management page;

Use programming language error, how to find the reason? In addition to the programming language itself error, in fact, the log log inside the hive information is more convenient to find the real reason for the error, there is an interface form of hive program run Log Web page will be very efficient.

That's right, hive. Starting with version 2.0, the HIVESERVER2 provides a simple Web UI interface where you can visually see the current linked session, history log, configuration parameters, and metric information.

The following sections describe the configuration of the HiveServer2 Web UI page, as well as the page description

First, the page configuration

localhost:conf a6$ cd/users/a6/applications/apache-hive-2.3.0-bin/conf

Localhost:conf a6$ VI hive-site.xml

Configuring the Web UI interface is simple, two parameters:

  <property>
    <name>hive.server2.webui.host</name>
    <value >0.0.0.0</value>
    <description>the host address the HiveServer2 WebUI would listen on</description >
  </property>
  <property>
    <name>hive.server2.webui.port</name>
    < Value>10002</value>
    

Integer to disable the Web ui</description>
  </property>

Above is the default HiveServer2 Web page configuration, the Red section can modify the IP and port of your favorite HiveServer2 log Management page. We don't make any changes here.

Second, remember, after modifying the configuration of Hive Hive-site.xml, be sure to restart the HiveServer2 service

First switch The hive to the Bin directory:

Localhost:bin a6$ cd  /users/a6/applications/apache-hive-2.3.0-bin/bin

localhost:bin a6$ JPS
24177 NameNode
20371
23668 runjar
24344 secondarynamenode
19513 hmaster
24251 DataNode
20140 Zookeepermainserver
18797 quorumpeermain
24749 Jps
24526 nodemanager 20447
thriftserver
24447 ResourceManager
localhost:bin a6$ kill-9 23668
localhost:bin a6$ kill-9 23668
-bash:kill: (23668) -No such process
[1]+  killed:9               hive--service hiveserver2 localhost:bin a6$
Hive--service Hiveser Ver2 &
[1] 24750
localhost:bin a6$ 2017-10-12 14:56:20:starting HiveServer2
slf4j:class Path Contains multiple SLF4J bindings.

....................................

Third, view the log information in the browser

as above, after modifying the configuration file, you must restart HiveServer2, enter in the browser http://localhost:10002/ or http://127.0.0.1:10002/
You can access the HiveServer2 Web UI management interface and then easily view its related execution log log

The current linked session is displayed on the home page, including the IP, user name, number of currently executing actions (queries), Total link duration, idle time, and, if a session executes the query, the following queries will display the query statement, execution time, and so on: