hive - 无法实例化 org.apache.hadoop.hive.metastore.HiveMetaStoreClient

Question

我刚刚安装了 hive 和 mysql..并将mysqlconnector复制到hive_home/lib文件夹

但是当我尝试在 hive> 中显示数据库并创建表命令时，提示出现如下错误:

create database saty;
FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

我的 hive_site.xml 是

<property>    
  <name>javax.jdo.option.ConnectionURL</name>         
  <value>jdbc:mysql://localhost:3306/hadoop?CreateDatabaseIfNotExist=true</value>         
  <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>hive.metastore.warehouse.dir</name>
  <value>/user/hive/warehouse</value>
  <description>location of default database for the warehouse</description>
</property>

我的文件系统中没有名为/user/hive/warehouse 的目录。

我使用 mkdir 命令创建了这些路径..并在重新启动后尝试..仍然收到错误..

问候，萨蒂亚

Answer 1

尝试指定这两个属性

<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>username</value>
<description>Username to use against metastore database</description>
</property>

<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>password</value>
<description>Password to use against metastore database</description>
</property>

同样，您的 mysql 登录用户名应该有权访问 JDBC 连接字符串中指定的数据库。这可以使用以下命令来实现

GRANT ALL ON Databasename.* TO username@'%' IDENTIFIED BY 'password';