title: Unable to create database path file:/user/hive/warehouse Error
body: <p>I have a 3 nodes cluster and I am getting following error while running some HIVE query </p>
  
  <blockquote>
    <p>FAILED: Error in metadata: MetaException(message:Unable to create
    database path file:/user/hive/warehouse/db_dut.db, failed to create
    database db_dut) FAILED: Execution Error, return code 1 from
    org.apache.hadoop.hive.ql.exec.DDLTask</p>
  </blockquote>
  
  <p>My hive-site.xml contains following property</p>
  
  <pre><code>       &lt;property&gt;
        &lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt;
        &lt;value&gt;jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create=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;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><strong>>jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create=true&lt;</strong> is correctly present at my local machine.</p>
  
  <p>When i gave hadoop fs -ls /user/hive ..following output came</p>
  
  <pre><code>[root@scaj02bda01 metastore]# hadoop fs -ls /user/hive
  Found 1 items
  drwxrwxrwx   - hive hive          0 2013-04-09 01:40 /user/hive/warehouse
  [root@scaj02bda01 metastore]# 
  </code></pre>
  
  <p>The default database location for warehouse is correctly mentioned in HDFS with all read write execute permission, but still i am getting the same error.</p>