Listing All The Tables In Apache Hive & Imapala

The purpose of this article is to let you know how to list all the tables that exists in the current database in Apache Hive that can be found with the Apache Impala as well.

Once you are Hive prompt, use the below command.

hive> SHOW TABLES;

list tables hive

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

list tables 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