What is the difference between the hive metastore in derby vs the one in hive/warehouse?
<p>This is probably a very basic question so please pardon the ignorance.</p>

<p>I understand there are two metastores that hive will use in a out of the box (hive tar.bin extract) vanilla setup. In my case I have hive 0.14.</p>

<p>There is one in a derby database--with a default folder name called <code>metastore_db</code> outside of hdfs.</p>

<p>And there is another in hdfs at /user/hive/warehouse.</p>

<p>What is the e difference between these two?</p>