第一步 下载
下载对应版本:
链接:hive3.1.3+mysql8+hadoop3.1.3
提取码:681v
第二步 安装
1、安装 hadoop
tar -zxvf hadoop-3.1.3.tar.gz
vim /etc/profile
# 设置环境变量
export HADOOP_HOME=/opt/hadoop/hadoop-3.1.3
export PATH=$PATH:$HADOOP_HOME/bin
export PATH=$PATH:$HADOOP_HOME/sbin
# 立刻生效
source /etc/profile
# 测试安装成功
hadoop version
2、安装 mysql
3、安装 hive
# 执行Hadoop安装目录bin下的start-all.sh,能否启动成功
start-all.sh
# 启动mysql
service mysql start
# mysql能否登录
mysql -u root -p
mysql创建hive用户:
CREATE USER 'hive'@'localhost' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'hive'@'localhost';
CREATE USER 'hive'@'%' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'hive'@'%';
CREATE USER 'hive'@'master' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'hive'@'master';
flush privileges;
create database myhive;
# 解压安装
cd hadoop-3.1.3/
#将apache-hive-3.1.3-bin.tar.gz放到Hadoop目录下
tar -zxvf apache-hive-3.1.3-bin.tar.gz
解压下载的文件,传输到服务器:
vim /etc/profile
# 设置环境变量
#hive
export HIVE_HOME=/opt/hadoop-3.1.3/apache-hive-3.1.3-bin
export PATH=$PATH:$HIVE_HOME/bin
# 立刻生效
source /etc/profile
# 初始化数据库
schematool -dbType mysql -initSchema
# 验证安装成果
hive