Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1741

Two tables having same time zone display different timestamps

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.10.1
    • Fix Version/s: 0.11.0, 0.12.0
    • Component/s: Storage
    • Labels:

      Description

      Create two tables with same scheme. Note 'GMT+9'.
      (Table names are timezone and timezone_text)

      CREATE EXTERNAL TABLE timezone 
      (t_timestamp TIMESTAMP, 
      t_date DATE) 
      USING TEXT WITH ('timezone'='GMT+9') 
      LOCATION 'hdfs://localhost:8020/timezone';
      

      Timezone table already has data.

      1980-4-1 01:50:30.010|1980-04-01
      80/4/1 1:50:30 AM|80/4/1
      1980 April 1 1:50:30|1980-04-01
      

      Then, copy data to timezone_text.

      INSERT INTO timezone_text SELECT * FROM timezone;
      

      Check timezone_text with some editor. It looks ok.

      1980-04-01 01:50:30.01+09|1980-04-01
      1980-04-01 01:50:30+09|1980-04-01
      1980-04-01 01:50:30+09|1980-04-01
      

      But in tsql, two tables show different time values.

      select * from timezone
      t_timestamp,  t_date
      -------------------------------
      1980-04-01 01:50:30.01,  1980-04-01
      1980-04-01 01:50:30,  1980-04-01
      1980-04-01 01:50:30,  1980-04-01
      
      select * from timezone_text
      t_timestamp,  t_date
      -------------------------------
      1980-03-31 16:50:30.01,  1980-04-01
      1980-03-31 16:50:30,  1980-04-01
      1980-03-31 16:50:30,  1980-04-01
      

        Attachments

        1. TAJO-1741.patch
          1 kB
          Jongyoung Park

          Issue Links

            Activity

              People

              • Assignee:
                eminency Jongyoung Park
                Reporter:
                eminency Jongyoung Park
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: