title: Hive Metastore asking for Derby DB in default
body: <p>Just for a query. Am having a hadoop 1 cluster.
  In hive am using Oracle/MySQL as a MetaStore DB, but when the MR job is being trigger I could see the Every Time Hive executing a Query Operation every time it seeking Derby DB instead of MySQL/Oracle DB.</p>
  
  <p>For Setting default DB in hive-site.xml and hive-default.xml have passed the </p>
  
  <pre><code>&lt;property&gt;
    &lt;name&gt;hive.stats.dbclass&lt;/name&gt;
    &lt;value&gt;jdbc:oracle&lt;/value&gt;
    &lt;description&gt;The default database that stores temporary hive statistics.&lt;/description&gt;
  &lt;/property&gt;
  </code></pre>
  
  <p>with other parameters like <strong>hive.stats.dbconnectionstring</strong>  or <strong>javax.jdo.option.ConnectionURL</strong>
  along with so is there any other changes required,
  As of now what have been applied is have removed the DERBY jar from the Lib location of the cluster, so while trying to access the Derby DB its getting failed and afterword it's checking Oracle/MySQL Connector to access the same.</p>
  
  <p>Any workaround can be done, as every time Hive is searching for DERBY DB, which causing bit a load for processing Job.</p>