How to find the default database in Hive

Question

Hi. I am new to Hive and I was going through the commands. While reading about the USE command I saw 2 usage.

1. USE database_name;
2. USE DEFAULT;

My question is that when I use the default database, how will I know which database I am using? Is there a way to know which is the default database?

Answer 1

Yes, you can find out which database is the default database. For that, you will first, change to the default database:

USE DEFAULT;

and then display the current database:

SELECT current_database()