Find the view created by hive

The current version of Hive generally supports view operations, but only supports logical views and does not support physical views, so views created under the Hive Shell are not available in hive's Data Warehouse directory, but can be seen in the MySQL metabase.

For example, the following hive creates a view: Name_classnum

How to find:

1 First determine that hive uses MySQL storage metadata (refer to Hive,mysql installed blog)

2 link MySQL

3. Hive using Hive;

4 Show details of TBLs

5. Find the View:

The view is now found.

According to this, you can see that the TBLs table stores a lot of information.

TBLs: Stores information about a table; DBS: Stores information about a database.

The Tbls:tbl_type field indicates whether the table created on the hive side is a managed table or an external table. You can view the following:

You can see that the managed table on the hive side is six and a view. Also on the hive side you can view:

Matches exactly.

Find the view created by hive