Cloudera Docs

Query metadata tables feature

From Hive, you can query Iceberg metadata tables as you would query a Hive table. For example, you can use projections, joins, filters, and so on.

You can also use the describe table metadata feature to get information about metadata.The following Iceberg metadata is available from Hive:
  • files
  • entries
  • snapshots
  • manifests
  • partitions

Hive Syntax

To reference a metadata table, use the full name of the table as shown in the following syntax: 
<DATABASE_NAME>.<TABLE_NAME>.<METADATA_TABLE_NAME>.history
<DATABASE_NAME>.<TABLE_NAME>.<METADATA_TABLE_NAME>.all_data_files
<DATABASE_NAME>.<TABLE_NAME>.<METADATA_TABLE_NAME>.all_manifests

Hive Example

SELECT * FROM default.table_a.files;