（三）hive与hive、RDBMS的集成配置与测试

1、运行环境

• hive-0.13.1
• hue-3.7.0
• hadoop-2.5.0
• centOS-6.4

2、hue.ini配置hive

hive的安装请参考文章：
hive的安装部署

hue.ini配置：

# Host where HiveServer2 is running.
# If Kerberos security is enabled, use fully-qualified domain name (FQDN).
hive_server_host=xuxudede.com

# Port where HiveServer2 Thrift server runs on.
hive_server_port=10000

# Hive configuration directory, where hive-site.xml is located
hive_conf_dir=/home/xusy/share/cdh5.3.6/hive-0.13.1-cdh5.3.6/conf

# Timeout in seconds for thrift calls to Hive service
server_conn_timeout=120

3、启动hiveserver2

$bin/hive --service hiveserver2

4、启动metastore

$ bin/hive --service metastore

5、启动hive

$bin/hive

6、启动hue

$ build/env/bin/supervisor

7、查看hue的8888端口web显示

如图：