Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
Description
Fetch task returns wrong results for Timestamp with local time zone datatype for Iceberg tables
Repro queries -
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 |
+-------------+----------------------------+
Attachments
Issue Links
- links to