【Flink】IllegalArgumentException: Embedded metastore is not allowed. Make sure you have set a valid

 问题背景

在Flink的sql-client客户端中执行连接hive的sql代码时出现如下错误，版本Flink1.13.6

Flink SQL>  create catalog test with(
>  'type'='hive',
> 'default-database'='default',
> 'hive-conf-dir'='/opt/hive/conf');

[ERROR] Could not execute SQL statement. Reason:
java.lang.IllegalArgumentException: Embedded metastore is not allowed. Make sure you have set a valid value for hive.metastore.uris

问题原因

需要再hive的配置文件中配置hive.metastore.uris参数，并启动hive的metastore

问题解决

1、去hive的安装目录下的conf目录中，修改hive-site.xml

vi /opt/hive/conf/hive-site.xml

在配置文件中添加，红色部分根据自己实际主机名修改

<property>
        <name>hive.metastore.uris</name&