List Tables in Hive Database

Raymond Raymond
Raymond
Stats
articleArticles 555
codeCode 5
imageDiagrams 54
descriptionNotebooks 0
chat_bubble_outlineThreads 8
commentComments 296
loyaltyKontext Points 6181
account_circle Profile
visibility 3,556 event 2022-07-08 access_time 2 years ago language English
share
Twitter Facebook LinkedIn
more_vert
arrow_upward arrow_downward

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.

More from Kontext
copyright This page is subject to Site terms.
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts