[ 
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 <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>


> 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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to