1.将hive-2.3.4拷贝到其他节点上 service端和clien端
到opt目录下 scp -r hive-2.3.4 node3:`pwd` scp -r hive-2.3.4 node4:`pwd`
2.在node3和node4上配置hive的环境变量
3.在node3(service端)配置hive-site.xml
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://node1/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>
</configuration>
4.在node4上配置hive-site.xml
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://node3:9083</value>
</property>
</configuration>
5.初始化元数据
schematool --dbType derby -initSchema
6.在服务端启动元数据服务
hive --service metastore
在node1运行mysql 在node3运行hive --service matestore 在node4上运行 hive