Spark默认Derby数据库改为Mysql配置

左手的ㄟ右手 2023-02-25 03:40 216阅读 0赞

在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>
        
        
        
        
    </configuration>

报错：

![70][]

解决方法：

进入mysql命令行  依次输入以下命令：

use mysql;  
show tables;  
select user, host from user;  
update user set host ='%' where user ='root';  
出现下面的错误 不用管![70 1][]

再输入以下命令执行刷新权限：flush privileges; 重启mysql

再次重启hive 一切正常![70 2][]

注意：进入mysql 后

use mysql;

select user, host from user;![70 3][]

会发现有两个user字段为空的用户 一定要删除：delete from user where user='';

![70 4][]

[70]: /images/20230209/ce77c3e8196d4e42ae460a19df622ee6.png
[70 1]: /images/20230209/a361c26a084d4810999219368cbdfe53.png
[70 2]: /images/20230209/4e85e4c7aefc4cffb3003b1367677cec.png
[70 3]: /images/20230209/94289d01d00746a3b2e9e717b8a69dc8.png
[70 4]: /images/20230209/59085bd61f3c493c9d57caf7dce1946d.png