vi hive-site.xml,加入下面内容后保存:
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://worker05:3306/hive?createDatabaseIfNotExist=true</value> //注意将worker05改为当前安装节点名,hive字眼改为之前配置的数据库名字
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value> //这个不用理
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value> //MySQL登录用户名
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value> //MySQL用户登录密码
<description>password to use against metastore database</description>
</property>
</configuration>