7(hive搭建模式2-多节点搭建)
node0001:mysql元数据服务
node0002:hive单节点模式
node0003:服务端
node0004:客户端
1,在0003节点搭建hive
node0002:scp -r /opt/sxt/hive/ node0003:/opt/sxt/
scp -r /opt/sxt/hive/ node0004:/opt/sxt/
node0003: vi /etc/profile (服务端)
export HIVE_HOME=/opt/sxt/hive
:$HIVE_HOME/bin
source /etc/profile
cd /opt/sxt/hive/conf/
vi hive-site.xml (修改0003机器上的配置,不该也行,为了做区分改一下,只修改这两个属性)
<property> <name>hive.metastore.warehouse.dir</name> <value>/user/hive/warehouse</value> </property> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://node0001/hive?createDatabaseIfNotExist=true</value> </property>
node0004: vi /etc/profile (客户端)
export HIVE_HOME=/opt/sxt/hive
:$HIVE_HOME/bin
source /etc/profile
cd /opt/sxt/hive/conf/
vi hive-site.xml (全部替换)
<property> <name>hive.metastore.warehouse.dir</name> <value>/user/hive/warehouse</value> </property> <property> <name>hive.metastore.uris</name> <value>thrift://node0003:9083</value> </property>
cd /opt/sxt/hadoop-2.6.5/share/hadoop/yarn/lib (jline-0.9.94.jar hadoop和hive版本不一致)
rm -rf jline-0.9.94.jar (删除hadoop下版本较低的)
cp /opt/sxt/hive/lib/jline-2.12.jar ./ (cp hive的高版本到当前目录)
2,启动hive服务端程序
node0003:hive --service metastore (阻塞式窗口,会卡住不动,再开另一个0003的窗口)
ss -nal (出现9083端口,则启动成功)
node0004:hive (成功后会在node0001的mysql,show databases; 出现hive库)