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
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
A: My hive server has not install java jdk.
a. download jdk-7u51-linux-x64.tar.gz
b. cp download/jdk-7u51-linux-x64.tar.gz to /usr/lib/jvm
d. untar it to /usr/lib/jvm/jdk/jdk1.7.0_51
e. change JAVA_HOME=/usr/lib/jvm/jdk/jdk1.7.0_51 in /etc/bash.bashrc
f. cp /usr/lib/jvm/jdk/jdk1.7.0_51/lib/tools.jar hive/lib/
References
https://cwiki.apache.org/confluence/display/Hive/HiveWebInterface
相关推荐
hive 开发UDF 使用maven工程 引发jar包缺失 hive 开发UDF 使用maven工程 引发jar包缺失
hive3.1.2编译后的驱动包
hive:/default/foobar hive -e "SELECT * FROM foobar" > $[OUTPUT]协议 !hive:/default/foobar <- !hive:/default/sample_07 [hive] CREATE TABLE IF NOT EXISTS ${env:TABLEOUT} LIKE ${env:TABLEIN}; INSERT ...
hadoop-hue-hive-cookbook TODO:在此处输入食谱说明。 支持的平台 TODO:列出您支持的平台。 属性 钥匙 类型 描述 ... " recipe[hadoop-hue-hive::default] " ] } 许可证和作者 作者:: YOUR_NAME ()
基于hive 0.13.1源码编译的hwi包,需要的同学欢迎下载。。。默认放到hive安装目录lib中,具体视hive-site.xml配置而定
Hive 事务设计
PS:Hive版本为0.10.0-cdh4.3.2 ###Tips 1.使用jdbc方式连接hiveserver,只能使用默认的数据库即default。官方文档说明如下: "jdbc:hive://localhost:10000/default". Currently, the only dbname supported is ...
hive-jdbc-1.1.0-cdh5.12.1 连接库 jar包,用于客户端连接cdh5.12.1 下部署的hive,很多第三方客户端可使用
自述文件概括Django 开放式计算工具版本:0.1 Hive 是一个试图帮助其他需要计算能力的项目的项目。 它是一个网络平台 ( ),它试图让任何人都可以使用高性能集群。 本项目使用docker运行计算程序。 这允许使安装过程...
This book is your go-to resource for using Hive: authors Scott Shaw, Ankur Gupta, David Kjerrumgaard, and Andreas Francois Vermeulen take you through learning HiveQL, the SQL-like language specific ...
http://blog.csdn.net/fangyuandoit/article/details/78860799
前端纳米度街机游戏说明 打开index.exe运行游戏 按Enter或单击底部的“确定”以查看简介/说明提示 使用箭头键在地图上四处移动(避免虫子和水!) 拿起钥匙并朝门移动到下一层 捡起箱子,为枪支和子弹获取子弹,以...
Hive-1.2.1-hwi配置
大数据安全-kerberos技术-hive安装包,hive版本:apache-hive-3.1.3-bin.tar.gz
1 Hive 概念与连接使用: 2 2 Hive支持的数据类型: 2 2.1原子数据类型: 2 2.2复杂数据类型: 2 2.3 Hive类型转换: 3 3 Hive创建/删除数据库 3 3.1创建数据库: 3 3.2 删除数据库: 3 4 Hive 表相关语句 3 4.1 Hive ...
hadoopHive:Acesso没有蜂箱
Hadoop Hive的节点绑定安装 npm install node-hive用法 hive = require('node-hive').for({ server:"hive.myserver" });hive.fetch("SELECT * FROM my_table", function(err, data) { data.each(function(record) { ...
问题 解决方案 在hadoop的配置文件core-site.xml增加如下配置: hadoop.proxyuser.hc.hosts * hadoop.proxyuser.hc.groups * 其中“hc”是连接beeline的用户。...重启hdfs:先stop-all.sh,再start-all.sh,否则...
hive-hwi-0.14.0.war 用于hwi 的配置