Raghav Aggarwal created HIVE-29803:
--------------------------------------
Summary: 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
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)
