[
https://issues.apache.org/jira/browse/HIVE-27513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17746853#comment-17746853
]
Sourabh Badhya commented on HIVE-27513:
---------------------------------------
Thanks [~ayushtkn] and [~dkuzmenko] for the reviews.
> Iceberg: Fetch task returns wrong results for Timestamp with local time zone
> datatype for Iceberg tables
> --------------------------------------------------------------------------------------------------------
>
> Key: HIVE-27513
> URL: https://issues.apache.org/jira/browse/HIVE-27513
> Project: Hive
> Issue Type: Improvement
> Components: Iceberg integration
> Reporter: Sourabh Badhya
> Assignee: Sourabh Badhya
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0-beta-1
>
>
> Fetch task returns wrong results for Timestamp with local time zone datatype
> for Iceberg tables
> Repro queries -
> {code:java}
> create external table ice_ts_4(a int, ts timestamp with local time zone)
> stored by iceberg;
> insert into ice_ts_4 values (1, current_timestamp());
> set hive.fetch.task.conversion=none;
> select * from ice_ts_4;
> +-------------+-------------------------------------+
> | ice_ts_4.a | ice_ts_4.ts |
> +-------------+-------------------------------------+
> | 1 | 2021-08-16 06:37:30.425 US/Pacific |
> +-------------+-------------------------------------+
> set hive.fetch.task.conversion=more;
> select * from ice_ts_4;
> +-------------+----------------------------+
> | ice_ts_4.a | ice_ts_4.ts |
> +-------------+----------------------------+
> | 1 | 2021-08-16 13:37:30.425 Z |
> +-------------+----------------------------+ {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
