[ https://issues.apache.org/jira/browse/HIVE-24508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17252772#comment-17252772 ]
Karen Coppage commented on HIVE-24508: -------------------------------------- Ah ok. In 3.1.3, then there will be this metadata in the parquet file: writer.time.zone=America/Los_Angeles that tells Hive how to read the file correctly. See HIVE-21290 for details on how this works. > 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)