Apache Hive Usage Example – How to Check the Current Hive Database

To know which Hive database you are currently using, Use the following command:

then the prompt will display Hive(DB_name)

Another Method is to edit hive-site.xml by pasting this code:

In second scenario, you can automatically display the Hive dabatabase name when you open terminal.