Querying Hive Table Metadata¶
With Data Catalog, you can query the metadata information of Hive tables in the OU, including the basic information, schema, partition list, and service list.
Querying Hive tables¶
Data Catalog supports querying the metadata information of all the Hive tables created in the OU. You can search for an Hive table by taking the following steps:
- Log in to the EnOS Console and select Data Catalog from the left navigation bar.
- In the left Type list, select Hive Table.
- In the search field, type a keyword to search for Hive tables, as shown below:
Note
The search keywords are case sensitive and can match the ID, name, and description of Hive tables.
Viewing search results¶
In the Hive table search result list, click the View icon in the Operations column, open the page of Hive table details, and view the following metadata of the Hive table.
Basic information¶
Under the Basic tab, view the basic information of the Hive table, including:
- Name and description of the Hive table
- Whether the Hive table is an external table
- Storage URL of the Hive table
- People who created the Hive table, and the time when the table was created and updated
- Tags attached to the Hive table
Click Attach Tags and use the pre-defined tag template to attach tags to the Hive table. Click the Edit or Delete icon to edit or delete tags that are attached to the Hive table.
Schema¶
Click the Schema tab to view detailed information of the Hive table schema, including:
- Column name
- Data type
- Is partition or not
- Description
Partition list¶
Click the Partitions tab to view the list of Hive table partitions, including:
- Partition name
- Data Type
- Time when the partition is created
Service list¶
Click the Services tab to view the list of Hive table services, including:
- Service name and description
- Service URL