Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to see a table belong to which database? or what all tables exists in a perticular database?

avatar
New Contributor

'Show tables' displays all the tables within Hive. Show databases displays all the database name.

How can I see database and tables exists inside same database?

e.g.

Database, table

db1, table1

db1,table2

db2,table1

1 ACCEPTED SOLUTION

avatar
Expert Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
2 REPLIES 2

avatar
Expert Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
hive> USE DB1; 

Now, commands such as SHOW TABLES, will list the tables in this database DB1