Arnab Karmakar has uploaded this change for review. ( 
http://gerrit.cloudera.org:8080/24405


Change subject: IMPALA-14783: Add time travel support for SHOW FILES on Iceberg 
tables
......................................................................

IMPALA-14783: Add time travel support for SHOW FILES on Iceberg tables

Extends SHOW FILES to accept FOR SYSTEM_TIME AS OF and FOR SYSTEM_VERSION
AS OF clauses for Iceberg tables.
Reuses the existing opt_asof grammar rule shared with SELECT time-travel.

Syntax:
SHOW FILES IN <table>
    [FOR SYSTEM_VERSION AS OF <integer_literal>]
    [FOR SYSTEM_TIME AS OF <timestamp_expr>]
    [PARTITION (<filter>)]

The time-travel clause is placed before the optional PARTITION clause.
Both can be combined to filter filesby snapshot and partition
simultaneously.

Testing:
- ParserTest: positive cases for new syntax and negative cases with
  invalid snapshot IDs.
- AnalyzeDDLTest: analysis-level validation with snapshot IDs,
  timestamps and partition filters. Negative cases with non-Iceberg tables.
- E2E tests with dynamic snapshot IDs and timestamps;
  covers version-based, timestamp-based, now(), partition filter combos,
  SELECT consistency checks, and negative cases

Change-Id: I09215c4527cdc585af5340d5bb573d9da877a0c9
---
M fe/src/main/cup/sql-parser.cup
M fe/src/main/java/org/apache/impala/analysis/ShowFilesStmt.java
M fe/src/test/java/org/apache/impala/analysis/AnalyzeDDLTest.java
M fe/src/test/java/org/apache/impala/analysis/ParserTest.java
A 
testdata/workloads/functional-query/queries/QueryTest/iceberg-show-files-time-travel.test
M tests/query_test/test_iceberg.py
6 files changed, 292 insertions(+), 32 deletions(-)



  git pull ssh://gerrit.cloudera.org:29418/Impala-ASF refs/changes/05/24405/1
-- 
To view, visit http://gerrit.cloudera.org:8080/24405
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: newchange
Gerrit-Change-Id: I09215c4527cdc585af5340d5bb573d9da877a0c9
Gerrit-Change-Number: 24405
Gerrit-PatchSet: 1
Gerrit-Owner: Arnab Karmakar <[email protected]>

Reply via email to