Hive搭建之remote分开

Mysql:node1
MetaStore Server:node3
Hive:node4

• 1 在node1上安装mysql

-yum install mysql-server –y

修改mysql的权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;

删除多余的权限

delete from user where host != '%';

刷新权限

flush privileges;

• 2 搭建服务端(node3)

修改Hive配置文件

cp hive-default.xml.template hive-site.xml

<property>  
  <name>hive.metastore.warehouse.dir</name>  
  <value>/user/hive/warehouse</value>  
</property>  
   
<property>  
  <name>javax.jdo.option.ConnectionURL</name>  
  <value>jdbc:mysql://node1:3306/hive?createDatabaseIfNotExist=true</value>  
</property>  
   
<property>  
  <name>javax.jdo.option.ConnectionDriverName</name>  
  <value>com.mysql.jdbc.Driver</value>  
</property>  
   
<property>  
  <name>javax.jdo.option.ConnectionUserName</name>  
  <value>root</value>  
</property>  
   
<property>  
  <name>javax.jdo.option.ConnectionPassword</name>  
  <value>123</value>  
</property> 

导入mysql的驱动包

cp /root/mysql-connector-java-5.1.32-bin.jar /home/hive-1.2.1/lib/

启动服务端

hive --service metastore

• 2.3 搭建客户端(node4)

修改Hive配置文件

cp hive-default.xml.template hive-site.xml

<property>  
  <name>hive.metastore.warehouse.dir</name>  
  <value>/user/hive/warehouse</value>  
</property>  
   
<property>  
  <name>hive.metastore.local</name>  
  <value>false</value>  
</property>  
  
<property>  
  <name>hive.metastore.uris</name>  
  <value>thrift://node3:9083</value>  
</property>  

修改hadoop的jline版本

cp /home/hive-1.2.1/lib/jline-2.12.jar /home/hadoop-2.5.1/share/hadoop/yarn/lib/