Hive: Hive Web Interface HWI

最新推荐文章于 2025-12-26 18:13:00 发布

原创最新推荐文章于 2025-12-26 18:13:00 发布 · 185 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #shell #大数据

Hive 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了HiveWebInterface（HWI）和WebHCat的使用方法、特性及配置步骤，包括如何通过它们进行Hive命令操作、查询执行、应用部署等，并提供了启动、访问和安装指南。

The Hive Web Interface, abbreviated as HWI, is a simple graphical user interface (GUI). HWI is an alternative to using the Hive command line interface.

Another web interface that can be used for Hive commands is WebHCat, a REST API (not GUI). With WebHCat, applications can make HTTP requests to access the Hive metastore (HCatalog DDL) or to create and queue Hive queries and commands, Pig jobs, and MapReduce or YARN jobs (either standard or streaming). WebHCat was formerly named Templeton.

Features of HWI

Schema Browsing
Detached Query Execution
No Local Installation

Configuration

You should not need to edit the defaults for the Hive Web Interface. HWI uses:

<property>
<name>hive.hwi.war.file</name>
<value>lib/hive-hwi-0.12.0.war</value>
<description>This sets the path to the HWI war file, relative to ${HIVE_HOME}. </description>
</property>

<property>
<name>hive.hwi.listen.host</name>
<value>0.0.0.0</value>
<description>This is the host address the Hive Web Interface will listen on</description>
</property>

<property>
<name>hive.hwi.listen.port</name>
<value>9999</value>
<description>This is the port the Hive Web Interface will listen on</description>
</property>

Start Up

export ANT_LIB=/usr/local/apache-ant-1.9.3/lib
bin/hive --service hwi

Java has no direct way of demonizing. In a production environment you should create a wrapper script.

nohup bin/hive --service hwi > /dev/null 2> /dev/null &

bin/hive --service hwi --help

Note:Normally, when running a command using & and exiting the shell afterwards, the shell will terminate the sub-command with the hangup signal (kill -SIGHUP <pid>). This can be prevented using nohup, as it catches the signal and ignores it so that it never reaches the actual application.

Access

http://192.168.122.1:9999/hwi