hive实验报告

1.hive安装地址

1）Hive官网地址
http://hive.apache.org/

2）下载地址
http://archive.apache.org/dist/hive/

2.hive安装部署

1. 把 apache-hive-3.1.2-bin.tar.gz上传到xshell的/opt/software目录下, 再解压apache-hive-3.1.2-bin.tar.gz到/opt/software/目录下面

2.安装文件

[root@master ~]# chown -R hadoop:hadoop /usr/local/src/hive

3.卸载 MariaDB 数据库

[root@master ~]# rpm -qa | grep mariadb mariadb-libs-5.5.56-2.el7.x86_64 [root@master ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

4.安装 MySQL 数据

[root@master tools]# cd mysql-5.7.18/

[root@master mysql-5.7.18]# vi /etc/my.cnf

[root@master mysql-5.7.18]# rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm

[root@master mysql-5.7.18]# mysql_secure_installation

[root@master mysql-5.7.18]# mysql -uroot -p

[root@master mysql-5.7.18]# tail -n 8 /etc/my.cnf

symbolic-links=0

default-storage-engine=innodb

innodb_file_per_table

collation-server=utf8_general_ci

init-connect='SET NAMES utf8'

character-set-server=utf8

log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

[root@master mysql-5.7.18]# systemctl status mysqld

5.配置 Hive 组件

[root@master ~]# vim /etc/profile

[root@master ~]# tail -n 2 /etc/profile

[root@master ~]# source /etc/profile

[root@master ~]# su - hadoop

[hadoop@master ~]$ vim /usr/local/src/hive/conf/hive-site.xml

6.初始化 hive 元数据

[hadoop@master tools]$ cp mysql-connector-java-5.1.46.jar /usr/local/src/hive/lib/

[hadoop@master tools]$ stop-all.sh

[hadoop@master tools]$ start-all.sh

[hadoop@master tools]$ hive