hive多用户的安装
集群搭建:
条件:node10服务端 node11客户端
【1】在node02中拷贝文件:
scp apache-hive-1.2.1-bin.tar.gz node10:`pwd`
scp apache-hive-1.2.1-bin.tar.gz node11:`pwd`
scp mysql-connector-java-5.1.47.jar node10:`pwd`
scp mysql-connector-java-5.1.47.jar node11:`pwd`
在 node10服务端:
【2】解压压缩包
tar zxvf apache-hive-1.2.1-bin.tar.gz
【3】配置环境变量
export HIVE_HOME=/opt/sxt/apache-hive-1.2.1-bin
export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_PREFIX/bin:$HADOOP_PREFIX/sbin:$ZOOKEEPER_PREFIX/bin:$HIVE_HOME/bin
【4】修改配置
cd /opt/sxt/apache-hive-1.2.1-bin/conf
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://node08/hive_remote?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false</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>ZZyy123@sai</value>
</property>
【5】上传mysql连接器
mv mysql-connector-java-5.1.47.jar /opt/sxt/apache-hive-1.2.1-bin/lib/
【6】统一Hadoop(删除不同的版本)和Hive jar包版本问题
cd /opt/sxt/hadoop-2.6.5/share/hadoop/yarn/lib/
mv jline-0.9.94.jar jline-0.9.94.jar.bak
cp /opt/sxt/apache-hive-1.2.1-bin/lib/jline-2.12.jar /opt/sxt/hadoop-2.6.5/share/hadoop/yarn/lib
【7】启动服务
hive --service metastore
【8】测试
#ss -nal | grep 9083
<-------------------------------------------->
node04客户端
【1】
tar vf apache-hive-1.2.1-bin.tar.gz
【2】
mv apache-hive-1.2.1-bin /opt/sxt/
【3】配置环境变量
export HIVE_HOME=/opt/sxt/apache-hive-1.2.1-bin
export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_PREFIX/bin:$HADOOP_PREFIX/sbin:$ZOOKEEPER_PREFIX/bin:$HIVE_HOME/bin
【4】修改配置
cd /opt/sxt/apache-hive-1.2.1-bin/conf
cp hive-default.xml.template hive-site.xml
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<!--可不配了,在0.10 0.11或者之后的HIVE版本 hive.metastore.local 属性不再使用,配置后,启动报WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist-->
<property>
<name>hive.metastore.local</name>
<value>false</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://node10:9083</value>
</property>
【5】上传mysql连接器
mv mysql-connector-java-5.1.47.jar /opt/sxt/apache-hive-1.2.1-bin/lib/
【6】统一Hadoop(删除不同的版本)和Hive jar包版本问题
cd /opt/sxt/hadoop-2.6.5/share/hadoop/yarn/lib/
mv jline-0.9.94.jar jline-0.9.94.jar.bak
cp /opt/sxt/apache-hive-1.2.1-bin/lib/jline-2.12.jar /opt/sxt/hadoop-2.6.5/share/hadoop/yarn/lib
【7】启动
hive
-----------------------------------------------
启动后警告:
20/07/28 02:07:54 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist
原因:在0.10 0.11或者之后的HIVE版本 hive.metastore.local 属性不再使用
解决:
<!--
<property>
<name>hive.metastore.local</name>
<value>true</value>
</property>
-->