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

Parquet Timestamp is local time NOT UTC when set TZ on linux

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • Parquet
    • None
    • Hide
      This issue is been fixed in HIVE-21290. we need setting set hive.local.time.zone=America/Los_Angeles or export TZ=Asia/Los_Angeles
      Show
      This issue is been fixed in HIVE-21290 . we need setting set hive.local.time.zone=America/Los_Angeles or export TZ=Asia/Los_Angeles

    Description

      reproduce steps:

      export TZ=America/Los_Angeles

      create external table t2(id int, v1 timestamp) stored as parquet LOCATION 'xxxxxx'

      insert into t2 values(1,CURRENT_TIMESTAMP)

      Then download real file from HDFS and you will find the timestamp is Los_Angeles NOT UTC. 

       

      Attachments

        Activity

          People

            wenjunma003 wenjun ma
            wenjunma003 wenjun ma
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: