Listing All The Databases In Apache Hive & Impala

The purpose of this article is to let you know how to list all the Apache Hive Metastore databases that can be found with the Apache Impala as well.

Once you are Hive prompt, use the below command.

hive> SHOW DATABASES;

list databases

The same command will help to list the databases in Apache Impala. Please note that Impala uses Hive metastore, so it shows the existing Hive databases.

list databases impala

Hope you liked this post.

Please click on the follow button to receive updates on latest posts.



One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s