Show Databases In Hive. The database creates in a default location of the hive warehouse. There is a workaround for this.
To list out the databases in hive warehouse enter the command show databases. Unfortunately there is no way to know which database is in use currently selected in hive shell. One option is to always use use database command to be sure every time you need to check the working database.
Msck repair table or alter table recover partitions show databases schemas tables.
Before you proceed make sure you have hiveserver2 started and connected to hive using beeline. Before you proceed make sure you have hiveserver2 started and connected to hive using beeline. In is an optional keyword in show. You can use hive cli property to show the existing database on the hive cli.
