五、hive-1.2.1安装

一、准备工作

1.下载安装包

hive-1.2.1：https://pan.baidu.com/s/1CNNMpQqBDE8I7-5ZrPkf4g 提取码：hztj

mysql-connector-java-5.1.32.jar:链接：https://pan.baidu.com/s/1V3m6YjeQnMiavcB5Ciu-SA 
提取码：03i7

上传到/export/software文件夹下

2.解压

[root@hadoop01 ]# cd /export/software/
[root@hadoop01 software]# tar -zxvf apache-hive-1.2.1-bin.tar.gz  -C /export/servers/
[root@hadoop01 software]# cd ../servers/

3.配置环境变量

[root@hadoop01 servers]# vi /etc/profile
# HIVE_HOME
export HIVE_HOME=/export/servers/apache-hive-1.2.1-bin
export PATH=$PATH:$HIVE_HOME/bin:
[root@hadoop01 servers]# source /etc/profile

二、安装

（一）、安装mysql

1.安装服务（hadoop01）

[root@hadoop01 ~]# wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
[root@hadoop01 ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm
[root@hadoop01 ~]# yum -y install mysql-community-server

若出现密钥问题，执行一下语句，否则不执行
[root@hadoop01 ~]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
[root@hadoop01 ~]# yum -y install mysql-community-server

2.启动MySQL服务

[root@hadoop01 ~]# systemctl start mysqld.service

查看运行状态
[root@hadoop01 ~]# systemctl status mysqld.service

3.查看初始密码

[root@hadoop01 ~]# grep "password" /var/log/mysqld.log

4.登录数据库，并更改密码

[root@hadoop01 ~]# mysql -uroot -p

请注意密码组合
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassWord1.';

允许远程登陆
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'NewPassWord1.' WITH GRANT OPTION;

更新权限表
mysql> FLUSH PRIVILEGES;

退出
mysql> exit;

（二）、安装hive

1.修改hive-env.sh

[root@hadoop01 ~]# cd /export/servers/apache-hive-1.2.1-bin/conf/
[root@hadoop01 conf]# cp hive-env.sh.template hive-env.sh
[root@hadoop01 conf]# vi hive-env.sh

像其中加入
export HADOOP_HOME=/export/servers/hadoop-2.7.4


[root@hadoop01 conf]# vi hive-site.xml




    
      javax.jdo.option.ConnectionURL
      jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true
    
    
      javax.jdo.option.ConnectionDriverName
      com.mysql.jdbc.Driver
    
    
      javax.jdo.option.ConnectionUserName
      root
    
    
      javax.jdo.option.ConnectionPassword
      NewPassWord1.
    

2.上传MySQL驱动包

[root@hadoop01 bin]# cd /export/servers/apache-hive-1.2.1-bin/lib

3.验证是否将默认的数据库更改为mysql数据库

[root@hadoop01 bin]# mysql -u root -p

mysql> show databases;
若出现hive则表示安装成功

hive与hbase的整合：