[
https://issues.apache.org/jira/browse/HIVE-29803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-29803:
----------------------------------
Labels: pull-request-available (was: )
> [Iceberg] Support ANCESTORS_OF snapshot lineage command
> -------------------------------------------------------
>
> Key: HIVE-29803
> URL: https://issues.apache.org/jira/browse/HIVE-29803
> Project: Hive
> Issue Type: Improvement
> Reporter: Raghav Aggarwal
> Assignee: Raghav Aggarwal
> Priority: Minor
> Labels: pull-request-available
>
> Iceberg provides the ability to trace the historical lineage of snapshots
> using
> _SnapshotUtil.ancestorsOf()_ . However, Hive currently lacks a native way for
> users to query this lineage directly from the beeline, without relying on
> external Iceberg catalogs or Spark. This patch introduces a new DDL operation:
> {code:java}
> ALTER TABLE table_name EXECUTE ANCESTORS_OF([snapshot_id]) {code}
> When executed from Beeline, it recursively looks up the provided snapshot (or
> the current table snapshot, if no argument is passed) and streams a formatted
> ASCII table containing the _snapshot_id_ and _timestamp_ms_ of all ancestors
> directly to the user's console.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
