List Tables in Hive Database

Raymond Tang Raymond Tang 0 6976 6.42 index 7/8/2022

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_tablein test_db.

hive sql

Join the Discussion

View or add your thoughts below

Comments