HIVE 分布式学习环境配置

首先完成hadoop环境配置，还没有配置hadoop的话，可以参考https://blog.csdn.net/hongxiao2016/article/details/90231500

官网下载hive，解压文件。

安装mysql:

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

 

rpm -ivh mysql57-community-release-el7-9.noarch.rpm

yum install mysql-server -y

启动mysql:

systemctl start mysqld.service

查看是否启动成功:

systemctl status mysqld.service

 查看生成的密码:

 

grep "password" /var/log/mysqld.log

 用刚刚的密码登录mysql:

关闭密码长度限制:

set global validate_password_policy=0;

set global validate_password_length=1;

修改密码:

ALTER USER 'root'@'localhost' IDENTIFIED BY '自己想设置的密码'; 

 顺便打开远程访问:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

 hive配置:

cp hive-default.xml.template hive-site.xml

修改 hive-site.xml的四个参数:

<property> <name>javax.jdo.option.ConnectionUserName</name> <value>登录用户名</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>mysql密码</value> </property> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://地址:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> </property>

下载mysql驱动,复制到lib目录

 

 

遇到一个错误:https://blog.csdn.net/hongxiao2016/article/details/90549012

完成。