[IMPALA-11368] Iceberg time-travel error message shows timestamp in UTC

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Resolved
• Fix Version/s: Impala 4.2.0, Impala 4.1.1
• Component/s: Frontend
• Labels: impala-iceberg ramp-up
• Epic Color: ghx-label-12
• Assignee: Li Penglin
• Reporter: Zoltán Borók-Nagy
• Created: 17/Jun/22 11:37
• Updated: 23/Aug/22 05:48
• Resolved: 12/Jul/22 02:39

Description

Repro:

[localhost:21050] default> describe history ice_t;
+-------------------------------+---------------------+--------------------+---------------------+
| creation_time                 | snapshot_id         | parent_id          | is_current_ancestor |
+-------------------------------+---------------------+--------------------+---------------------+
| 2022-06-17 11:18:08.893000000 | 860514146484624738  | NULL               | TRUE                |
| 2022-06-17 11:18:09.866000000 | 3753528011626879929 | 860514146484624738 | TRUE                |
+-------------------------------+---------------------+--------------------+---------------------+

[localhost:21050] default> select * from ice_t for system_time as of '2022-06-17 11:00:00';
ERROR: IllegalArgumentException: Cannot find a snapshot older than 2022-06-17 09:00:00.000

In the FOR SYSTEM_TIME AS OF clause we expect timestamps in the local timezone, while the error message shows the timestamp in UTC timezone. It should also use the local timezone instead.

Issue Links

• links to: The error message of 'org.apache.iceberg.util.SnapshotUtil#snapshotIdAsOfTime' can be misleading to users.