一 mysql 安装
#hive安装包
apache-hive-2.3.7-bin.tar.gz
#mysql
mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
#jdbc驱动
mysql-connector-java-5.1.46.jar
整体步骤:
1、安装mysql
2、安装配置hive
3、Hive添加常用配置
sz上传,下载rz
1.删除MariaDB,与要安装的mysql有冲突
rpm -aq | grep mariadb
2.安装依赖
yum install net-pools -y
yum install net-tools -y
3.安装MySQL
#解压缩
tar xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
#依次运行以下命令
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
4.启动数据库
#查看状态
systemctl status mysqld
#启动
systemctl start mysqld
5.查找root密码
grep password /var/log/mysqld.log
6.修改root口令
mysql -u root -p
#设置口令强度:设置口令密码
set global validata_password_policy=0;
set password for 'root'@'localhost' = password('12345678');
flush privileges;
7.创建hive用户
#进入mysql后
create user 'hive'@'%' identified by '12345678';
grant all on *.* to 'hive'@'%';
二 Hive安装
1.下载Hive软件,并解压缩
cd /opt/lagou/software
tar zxvf apache-hive-2.3.7-bin.tar.gz -C ../servers
cd ../servsers
#重命名
mv apache-hive-2.3.7-bin.tar.gz hive-2.3.7
2.修改环境变量
#修改环境变量
export HIVE_HOME=/opt/lagou/servers/hive-2.3.7
export PATH=$PATH:$HIVE_HOME/bin
#执行并生效
source /etc/profile
#测试
cd $HIVE_HOME
3.修改Hive配置
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<