🚀 News: We are launching the Kontext Labs AI-Native Data Intelligence Platform Pilot! Click here to join our pilot program.

List Tables in Hive Database

2022-07-08 hive sql

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.