1、集成Hive与Impala
- 关闭所有Hive、Impala的服务进程
- 配置Hue中与Hive的关联hue.ini:1000-1061行
hive_server_host=node-03
hive_server_port=10000
hive_conf_dir=/export/servers/hive-1.1.0-cdh5.14.0/conf
auth_username=root
auth_password=123456
enable_new_create_table=true
- 配置Hue中与Impala的关联hue.ini:1065-1112行
server_host=node-02
server_port=21050
impala_conf_dir=/etc/impala/conf/
start-metastore.sh
start-hiveserver2.sh
service impala-state-store start
service impala-catalog start
service impala-server start
service impala-server start
2、MySQL
- 配置Hue中与MySQL的关联hue.ini:1544-1580行左右
[[[mysql]]]
nice_name="MySQL"
engine=mysql
host=node-03
port=3306
user=root
password=123456
cd /export/servers/hue-3.9.0-cdh5.14.0
build/env/bin/supervisor
3、验证
select
region,
round(avg(sprice),2) as avgprice
from db_lianjia.tb_lianjia
group by region;