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/

• 啟動hive

start-metastore.sh
start-hiveserver2.sh

• 啟動每臺機器的impala服務
  • 第二臺

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

• 啟動Hue

cd /export/servers/hue-3.9.0-cdh5.14.0
build/env/bin/supervisor

3、驗證

• Hive
  
  
  

select
region,
round(avg(sprice),2) as avgprice
from db_lianjia.tb_lianjia
group by region;

• Impala
  
  
• MySQL