[jira] [Created] (IMPALA-10947) SQL support for querying Iceberg metadata

["Zoltán Borók-Nagy (Jira)" <ji...@apache.org>]

Zoltán Borók-Nagy created IMPALA-10947:
------------------------------------------

             Summary: SQL support for querying Iceberg metadata
                 Key: IMPALA-10947
                 URL: https://issues.apache.org/jira/browse/IMPALA-10947
             Project: IMPALA
          Issue Type: New Feature
          Components: Frontend
            Reporter: Zoltán Borók-Nagy


HIVE-25457 added support for querying Iceberg table metadata to Hive.

They support the following syntax:
SELECT * FROM default.iceberg_table.history;

Spark uses the same syntax: https://iceberg.apache.org/spark-queries/#history

Other than "history", the following metadata tables are available in Iceberg:
The following metadata tables are available in Iceberg:
* ENTRIES,
* FILES,
* HISTORY,
* SNAPSHOTS,
* MANIFESTS,
* PARTITIONS,
* ALL_DATA_FILES,
* ALL_MANIFESTS,
* ALL_ENTRIES

Impala currently only supports "DESCRIBE HISTORY <tbl>". The above SELECT syntax would be more convenient for the users, also it would be more flexible as users could easily define filters in WHERE clauses. And of course we would be consistent with other engines.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org