在窗口上安装配置单元时出错



我试图在Windows上安装hive。我几乎完成了我的安装。但是在盯着蜂巢命令时,我收到以下错误。

Error applying authorization policy on hive configuration: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
Beeline version 2.1.1 by Apache Hive
Error applying authorization policy on hive configuration: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
Connection is already closed.

这是我的蜂巢网站.xml

<configuration>
 <property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/metastore?createDatabaseIfNotExist=true</value>
<description>metadata is stored in a MySQL server</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>MySQL JDBC driver class</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hiveusera</value>
<description>user name for connecting to mysql server </description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hivepassword</value>
<description>password for connecting to mysql server </description>
</property>
<property>
 <name>hive.metastore.uris</name>
 <value>thrift://localhost:9083</value>
 <description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>
  </property>
</configuration>

我正在使用MySQL作为我的蜂巢的后端

我尝试了所有可能的解决方案删除 *.lck,将 mysql-connector-java-5.1.42-bin 复制到/lib

对我没有任何帮助。

我得到了答案,我实际上缺少MySQL中元存储的模式。我现在添加它并且可以正常工作:)

最新更新