title: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
body: <p>i just installed hive and mysql..
  and copied the mysqlconnector to the hive_home/lib folder</p>
  
  <p>but when i try show databases and create table commands in the hive> prompt giving me the error as below: </p>
  
  <pre><code>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
  </code></pre>
  
  <p>and my hive_site.xml is</p>
  
  <pre><code>&lt;property&gt;    
    &lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt;         
    &lt;value&gt;jdbc:mysql://localhost:3306/hadoop?CreateDatabaseIfNotExist=true&lt;/value&gt;         
    &lt;description&gt;JDBC connect string for a JDBC metastore&lt;/description&gt;
  &lt;/property&gt;
  
  &lt;property&gt;
    &lt;name&gt;javax.jdo.option.ConnectionDriverName&lt;/name&gt;
    &lt;value&gt;com.mysql.jdbc.Driver&lt;/value&gt;
    &lt;description&gt;Driver class name for a JDBC metastore&lt;/description&gt;
  &lt;/property&gt;
  
  &lt;property&gt;
    &lt;name&gt;hive.metastore.warehouse.dir&lt;/name&gt;
    &lt;value&gt;/user/hive/warehouse&lt;/value&gt;
    &lt;description&gt;location of default database for the warehouse&lt;/description&gt;
  &lt;/property&gt;
  </code></pre>
  
  <p>and i dont have a directory called /user/hive/warehouse in my file system. </p>
  
  <p>i created these path with mkdir command.. and tried after reboot..
  bout still getting the error..</p>
  
  <p>regards,
  satya</p>