Hadoop Hue 3.9.0详细安装文档

HUE3.9.0详细安装文档

友情提示，安装任何LUW软件之前，务必先阅读readme自带文档，里面有很多关键信息，不要拿着就开搞，浪费半天时间发现一大堆错误。

1 环境准备 ................................................................................................................................................................................................................................................. 4 2 启动HIVE后台进程(确保HIVE安装OK) .............................................................................................................................................................................................. 4 3 安装OS依赖包 ....................................................................................................................................................................................................................................... 4 4 编译安装HUE ......................................................................................................................................................................................................................................... 6

4.1 编译Hue(保持服务器网络畅通)................................................................................................................................................................................................. 6 4.2 修改配置文件hue.ini（可参考为知笔记）............................................................................................................................................................................... 7 4.3 hue.ini关键项说明 ....................................................................................................................................................................................................................... 8 4.4 启动Hue ..................................................................................................................................................................................................................................... 11 4.5 登录HUE .................................................................................................................................................................................................................................... 11 4.6 执行HIVE查询语句 ................................................................................................................................................................................................................... 13 5 HUE元数据库改为Mysql ...................................................................................................................................................................................................................... 14

5.1 停止HUE服务 ........................................................................................................................................................................................................................... 14 5.2 备份sqllite数据库 ..................................................................................................................................................................................................................... 14 5.3 删除desktopdb.json中所有 useradmin.userprofile 的对象，以下是例子 ............................................................................................................................ 14 5.4 安装配置Mysql数据库 ............................................................................................................................................................................................................. 16

5.4.1 安装MYSQL客户端 ........................................................................................................................................................................................................ 16 5.4.2 安装MYSQL连接器 ........................................................................................................................................................................................................ 17 5.4.3 安装MYSQL服务器 ........................................................................................................................................................................................................ 17 5.4.4 配置 /etc/my.cnf .............................................................................................................................................................................................................. 18 5.4.5 启动MySQL服务 ............................................................................................................................................................................................................ 19 5.4.6 修改密码（此步可不做）.............................................................................................................................................................................................. 19 5.4.7 配置MySQL开机自启 .................................................................................................................................................................................................... 20 5.4.8 创建数据库hue .............................................................................................................................................................................................................. 21 5.4.9 给hue授权 ..................................................................................................................................................................................................................... 21 5.4.10 Load any backed up data: ............................................................................................................................................................................................... 22 5.4.11 (InnoDB only) Drop the foreign key: ............................................................................................................................................................................... 23

5.4.12 再次启动HUE ............................................................................................................................................................................................................... 23

6 FAQ帮助 ................................................................................................................................................................................................................................................. 24

6.1 Mysql报错ERROR 1045 .............................................................................................................................................................................................................. 24 6.2 filelists.sqlite.bz2 from base: [Errno -1] 的解决方法 ................................................................................................................................................................. 25 6.3 Cannot retrieve repository metadata (repomd.xml) for repository:xxxxxx ................................................................................................................................. 26

1 环境准备

CentOS-6.8 (Final) JDK-1.8 maven-3.3.9 Git-1.7.1 Hue-3.9.0 Hadoop-2.7.3 Hive-1.2.1 Python-2.6.6

2 启动HIVE后台进程(确保HIVE安装OK)

hive --service metastore & hive --service hiveserver2 &

同时用 ps -ef|grep hive检查是否启动成功

3 安装OS依赖包