官网下载hive，解压文件。 安装mysql: wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10.noarch.rpm yum -y install mysql-community-server 启动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目录
