Sourabh Badhya created HIVE-27513:
-------------------------------------
Summary: 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
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)
