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 email@example.com.
We assure you that we will get back to you within 24 hours
edureka! Solution Team
Website - www.edureka.co
Edureka claims 1st position at Deloitte's Technology Fast 50 India 2014