Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

Question

i just installed hive and mysql.. and copied the mysqlconnector to the hive_home/lib folder

but when i try show databases and create table commands in the hive> prompt giving me the error as below:

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

and my hive_site.xml is

<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>

and i dont have a directory called /user/hive/warehouse in my file system.

i created these path with mkdir command.. and tried after reboot.. bout still getting the error..

regards, satya

Answer 1

Try Specifying these two properties

<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>

And Similarly the username of your mysql login should have the permission to access the db sepcified in the JDBC connection string. This Can be acheived using the following command

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