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:

  1. Log in to the EnOS Console and select Data Catalog from the left navigation bar.
  2. In the left Type list, select Hive Table.
  3. In the search field, type a keyword to search for Hive tables, as shown below:
../../_images/table_search_result.png

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.

../../_images/table_basic_info.png

Schema

Click the Schema tab to view detailed information of the Hive table schema, including:

  • Column name
  • Data type
  • Is partition or not
  • Description
../../_images/table_schema.png

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
../../_images/table_partition.png

Service list

Click the Services tab to view the list of Hive table services, including:

  • Service name and description
  • Service URL