HCatalog Tutorial
HCatalog CLI Commands
HCatalog APIS
HCatalog Useful Resources
Selected Reading
HCatalog CLI Commands
- HCatalog - Indexes
- HCatalog - Show Partitions
- HCatalog - Show Tables
- HCatalog - View
- HCatalog - Alter Table
- HCatalog - Create Table
HCatalog APIS
HCatalog Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
HCatalog - Show Tables
HCatalog - Show Tables
You often want to pst all the tables in a database or pst all the columns in a table. Obviously, every database has its own syntax to pst the tables and columns.
Show Tables statement displays the names of all tables. By default, it psts tables from the current database, or with the IN clause, in a specified database.
This chapter describes how to pst out all tables from the current database in HCatalog.
Show Tables Statement
The syntax of SHOW TABLES is as follows −
SHOW TABLES [IN database_name] [ identifier_with_wildcards ];
The following query displays a pst of tables −
./hcat –e "Show tables;"
On successful execution of the query, you get to see the following response −
OK emp employee Time taken: 5.3 secondsAdvertisements