1.下载mysql
wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'
2.安装mysql
rpm -Uvh mysql57-community-release-el7-11.noarch.rpm
yum install -y mysql-community-server
3.设置免密登录mysql
vim /etc/my.cnf
skip-grant-tables=1
systemctl restart mysqld
4.修改mysql登录密码
mysql -uroot
use mysql;
update user set password=password("123456") where user="root";
update user set authentication_string = password('123456'),password_last_changed=now() where user='root';
flush privileges;
vim /etc/my.cnf
去掉原来设置的免密
mysql -root -p
use mysql
set global validate_password_policy=0;
set global validate_password_length=6;
set names utf8;
alter user 'root'@'localhost' identified by '123456';
exit;
system restart mysqld
5.远程登录授权
mysql -u root -p
use mysql;
select user host from user;
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456"; //若查询没有root授权
6.mysql开机启动
sysctl enable mysqld
sysctl daemon-reload
7.安装hive
cp apache-hive-1.2.2-bin.tar.gz /usr/local/src
tar -zxvf apache-hive-1.2.2-bin.tar.gz
cd apache-hive-1.2.2-bin/conf
mv hive-env.sh.template hive-env.sh
vim hive.site.xml
插入默认配置修改mysql密码
vim hive-env.sh
export HADOOP_HOME=/usr/local/src/hadoop-2.6.5
export HIVE_CONF_DIR=/usr/local/src/apache-hive-1.2.2-bin/conf
export HIVE_AUX_JARS_PATH=/usr/local/src/apache-hive-1.2.2-bin/lib
添加jar包
tar -xzvf mysql-connector-java-5.1.46.tar.gz
cd mysql-connector-java-5.1.46
mv mysql-connector-java-5.1.46.jar /usr/local/src/apache-hive-1.2.2-bin/lib
替换hadoop yarn里jline jar包
cd /usr/local/src/apache-hive-1.2.2-bin/lib
cp jline-2.12.jar /usr/local/src/hadoop-2.6.5/share/hadoop/yarn/lib
cd /usr/local/src/hadoop-2.6.5/share/hadoop/yarn/lib
rm -rf jline-0.9.94.jar
设置环境变量
vim ~/.bashrc
export HIVE_HOME=/usr/local/src/apache-hive-1.2.2-bin
export PATH=$PATH:$HIVE_HOME/bin
source ~/.bashrc
将配置好的hive和环境变量拷贝到slave相应目录
先启动hadoop,再启动hive