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 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;