title: Configuring Hive to run in Local Mode
body: <p>Hi I am trying to run Hive in local mode, I have set the HIVE_OPTS environment variable</p>
  
  <pre><code>export HIVE_OPTS='-hiveconf 
  mapred.job.tracker=local 
  -hiveconf fs.default.name=file:////&lt;myhomedir&gt;/hivelocal/tmp 
  -hiveconf hive.metastore.warehouse.dir=file:////&lt;myhomedir&gt;/hivelocal/warehouse
  -hiveconf javax.jdo.option.ConnectionURL=jdbc:derby:;databaseName=/&lt;myhomedir&gt;/hivelocal/metastore_db;create=true'
  </code></pre>
  
  <p>and connected to hive using <code>hive</code> client</p>
  
  <p>when I create the table(name <code>demo</code>), I still see the table is getting created in the <code>default</code> database in HDFS. I was expecting the table to be created in the local file system(<code>file:///</code>) as I have the set the warehouse using <code>hive.metastore.warehouse.dir=file:////&lt;myhomedir&gt;/hivelocal/warehouse</code></p>
  
  <p>Am I missing something here?</p>
  
  <p>PS : I am using Cloudera distribution</p>