一、准备工作
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
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>NewPassWord1.</value>
</property>
</configuration>
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的整合: