The possible reason could be, you logged into hive shell from different location and hence the default derby meta store changed.Kindly check below screen shots:

Step 1) I have logged into hive shell from /home/edureka/Desktop

Now  I have created a db named sumit.

After this, I exited from hive shell and re logged in to it from a different location, ie; /home/edureka.

Here, show databases will not show the database sumit that we created because the derby metastore changed.

But the same database,ie; sumit resides in hdfs.

Hope this resolves your query

In case of any further issue,feel free to revert.

Please note if you are not happy with the response on this ticket, please escalate it to

We assure you that we will get back to you within 24 hours



Sumit Anand

edureka! Solution Team

Website -

Edureka claims 1st position at Deloitte's Technology Fast 50 India 2014