hadoop之hive环境安装

1、 集群环境
192.168.67.10
192.168.67.11
192.168.67.12
2、下载软件包
#master
wget http://mirror.bit.edu.cn/apache/hive/hive-1.2.2/apache-hive-1.2.2-bin.tar.gz
tar zxvf apache-hive-1.2.2-bin.tar.gz
3、修改hive配置文件
#master
cd apache-hive-1.2.2-bin/conf
vim hive.xml


javax.jdo.option.ConnectionURL
jdbc:mysql://master:3306/hive?createDatabaseIfNotExist=true


javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver


javax.jdo.option.ConnectionUserName
root


javax.jdo.option.ConnectionPassword
hadoop

4、修改环境变量
#master、slave1、slave2
vim ~/.bashrc
export HIVE_HOME=/usr/local/src/apache-hive-1.2.2-bin
export PATH=$HIVE_HOME/bin:$PATH
#刷新环境变量
source ~/.bashrc
5、安装mysql
#master
yum -y install mysql-server
chkconfig –add mysqld
service mysqld start
#配置MySQL Root用户密码
mysqladmin -uroot password hadoop
6、安装mysql连接工具
#master
●下载安装包
wget https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-5.1.44.tar.gz
tar zxvf mysql-connector-java-5.1.44.tar.gz
●复制连接库文件
cp mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar /usr/local/src/apache-hive-1.2.2-bin/lib
7、拷贝安装包
#master
scp -r /usr/local/src/apache-hive-1.2.2-bin root@slave1:/usr/local/src/apache-hive-1.2.2-bin
scp -r /usr/local/src/apache-hive-1.2.2-bin root@slave2:/usr/local/src/apache-hive-1.2.2-bin
8、启动hive服务
#master
hive
—-这一步因为hadoop_home的环境变量配置错了，找了好久正确的是HADOOP_HOME=/usr/local/src/hadoop-2.8.2
export PATH=$PATH:$HADOOP_HOME/sbin