How to View Hive Tables & Columns

To view all tables and columns in Hive, you can use the following command:

1. View all tables.

show tables;

1. View detailed information about the table, including field information.

describe <table_name>;

For example, to view the field information of a table named employee, you can execute the following command:

describe employee;

In this way, you can view all the field information in the employee table.