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.

The following Iceberg metadata tables are 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>

Hive Example

SELECT * FROM default.table_a.files;