List Tables in Hive Database

visibility 55 access_time 2 months ago languageEnglish
more_vert

The following code snippet shows you how to list all the tables within a Hive database.

Code snippet

show tables in [database name];

Example:

show tables in test_db;
test_table

The result shows that there is only one table named test_table in test_db.

copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts