1.安装mysql
2.登录mysql,创建数据库
create database myhive;
3.修改hive/conf/hive-site.xml文件,配置Mysql驱动和连接信息
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.jdbc.mysql.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.100.1:3306/myhive?ssl=false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>Username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root123</value>
</property>
4.下载mysql驱动包,放入hive/lib下,初始化数据库