在classpath下修改hive-site.xml
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.222.3:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
<property>
<name>hive.metastore.local</name>
<value>true</value>
</property>
<!-- <property> -->
<!-- <name>hive.metastore.uris</name> -->
<!-- <value>thrift://192.168.1.188:9083</value> -->
<!-- </property> -->
</configuration>
报错:
解决方法:
进入mysql命令行 依次输入以下命令:
use mysql;
show tables;
select user, host from user;
update user set host ='%' where user ='root';
出现下面的错误 不用管
再输入以下命令执行刷新权限:flush privileges; 重启mysql
再次重启hive 一切正常
注意:进入mysql 后
use mysql;
select user, host from user;
会发现有两个user字段为空的用户 一定要删除:delete from user where user='';