[jira] [Updated] (HIVE-29803) [Iceberg] Support ANCESTORS_OF snapshot lineage command

["Raghav Aggarwal (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-29803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Raghav Aggarwal updated HIVE-29803:
-----------------------------------
    Summary: [Iceberg] Support ANCESTORS_OF snapshot lineage command  (was: Iceberg: Support ANCESTORS_OF snapshot lineage command)

> [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
>
> 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)