You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2022/07/02 03:27:00 UTC
[jira] [Commented] (IMPALA-11368) Iceberg time-travel error message shows timestamp in UTC
[ https://issues.apache.org/jira/browse/IMPALA-11368?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17561663#comment-17561663 ]
ASF subversion and git services commented on IMPALA-11368:
----------------------------------------------------------
Commit 9c96855146071688f9ab2386839720d6180de011 in impala's branch refs/heads/master from LPL
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=9c9685514 ]
IMPALA-11368: Iceberg time-travel error message should show timestamp in local timezone
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.
The error message should show timestamp in local timezone.
Testing:
- Add e2e test
Change-Id: Iba5d5eb65133f11cc4eb2fc15a19f7b25c14cc46
Reviewed-on: http://gerrit.cloudera.org:8080/18675
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> Iceberg time-travel error message shows timestamp in UTC
> --------------------------------------------------------
>
> Key: IMPALA-11368
> URL: https://issues.apache.org/jira/browse/IMPALA-11368
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Reporter: Zoltán Borók-Nagy
> Assignee: LiPenglin
> Priority: Major
> Labels: impala-iceberg, ramp-up
>
> Repro:
> {noformat}
> [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
> {noformat}
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org