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;



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.



Hope you liked this post.

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