List Tables in Hive Database

2022-07-08 hivesql

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.