title: Configuring hive in local mode
body: <p>I am trying to set up hive-0.9.0 in local mode configuration. In /conf, I have created hive-site.xml and specified the property for warehouse folder.
  But I think hive is not using my defined location as it is not creating the 'warehouse' folder in that location.</p>
  
  <p>Also, is it necessary to have hadoop cluster running in local mode hive configuration as it throws error when I issue any DDL commands without starting hadoop cluster.</p>
  
  <pre><code>FAILED: Error in metadata: MetaException(message:Got exception: java.net.ConnectException Call to localhost/127.0.0.1:54310 failed on connection exception: java.net.ConnectException: Connection refused)
  </code></pre>
  
  <p>The contents of hive-site.xml is as follows:</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  
  &lt;?xml-stylesheet type="text/xsl" href="configuration.xsl"?&gt;
  
  &lt;configuration&gt;
  
  &lt;property&gt;
  
  &lt;name&gt;hive.metastore.warehouse.dir&lt;/name&gt;
  
  &lt;value&gt;/home/hadoopuser/hive/warehouse&lt;/value&gt;
  
  &lt;description&gt;
  
  Local or HDFS directory where Hive keeps table contents.
  
  &lt;/description&gt;
  
  &lt;/property&gt;
  
  &lt;property&gt;
  
  &lt;name&gt;hive.metastore.local&lt;/name&gt;
  
  &lt;value&gt;true&lt;/value&gt;
  
  &lt;description&gt;
  
  Use false if a production metastore server is used.
  
  &lt;/description&gt;
  
  &lt;/property&gt;
  
  &lt;property&gt;
  
  &lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt;
  
  &lt;value&gt;jdbc:derby:;databaseName=/home/hadoopuser/hive/metastore_db;create=true&lt;/value&gt;
  
  &lt;description&gt;
  
  The JDBC connection URL.
  
  &lt;/description&gt;
  
  &lt;/property&gt;
  
  &lt;/configuration&gt;
  </code></pre>