You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "wenjun ma (Jira)" <ji...@apache.org> on 2021/01/05 01:30:00 UTC

[jira] [Resolved] (HIVE-24508) Parquet Timestamp is local time NOT UTC when set TZ on linux

     [ https://issues.apache.org/jira/browse/HIVE-24508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

wenjun ma resolved HIVE-24508.
------------------------------
    Release Note: 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 
      Resolution: Fixed

> Parquet Timestamp is local time NOT UTC when set TZ on linux
> ------------------------------------------------------------
>
>                 Key: HIVE-24508
>                 URL: https://issues.apache.org/jira/browse/HIVE-24508
>             Project: Hive
>          Issue Type: Bug
>          Components: Parquet
>            Reporter: wenjun ma
>            Assignee: wenjun ma
>            Priority: Major
>             Fix For: 3.1.3
>
>
> 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. 
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)