apache 官网下载
安装mysql
yum install MySQL
添加访问权限
mysql -u root -p
use mysql;
update user set host ='%' where user='root';
flush privileges;
修改密码 鉴于MySQL8.0.26初始化为空密码,设置一下,
set password ="your password";
下载hive
解压到指定目录
tar xzvf apache-hive-2.3.9-bin -C /export/servers
添加环境变量
#hive
export HIVE_HOME=/export/servers/apache-hive-2.3.9-bin
export PATH=$PATH:$HIVE_HOME/bin
source /etc/profile
加入mysql 驱动
从下载好的压缩包中解压出mysql-connector-java-8.0.23.jar,复制
到/hive/lib ⽬录中。
cp hive-default.xml.template hive-site.xml
hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.88.131:3306/hive?useUnicode=true&characterEncoding=utf-8&useSSL=false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.cj.jdbc.Driver</value>
</property>
<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
</property>
<!--元数据存储授权-->
<property>
<name>hive.metastore.event.db.notification.api.auth</name>
<value>false</value>