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:
To reference a metadata table, use the full name of the table as shown in the following syntax:
SELECT * FROM default.table_a.files;