Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-27513

Iceberg: Fetch task returns wrong results for Timestamp with local time zone datatype for Iceberg tables

    XMLWordPrintableJSON

Details

    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

          Activity

            People

              sbadhya Sourabh Badhya
              sbadhya Sourabh Badhya
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: