[ https://issues.apache.org/jira/browse/HIVE-24618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kishen Das reassigned HIVE-24618: --------------------------------- Assignee: Kishen Das > Hive JDBC should use timestamp in UTC > ------------------------------------- > > Key: HIVE-24618 > URL: https://issues.apache.org/jira/browse/HIVE-24618 > Project: Hive > Issue Type: Bug > Components: JDBC > Reporter: Kishen Das > Assignee: Kishen Das > Priority: Major > > Hive moved away from java.sql.Timestamp to java.time.LocalDateTime ( > https://issues.apache.org/jira/browse/HIVE-12192 ), in order to be consistent > w.r.t timestamp field irrespective of the current time zone. For example: for > time zones like America/Los_Angeles that alternate between PST and PDT, time > can be shown based on effective current time zone, which is set in the > current SQL session. Hive JDBC handler should follow suit and use > LocalDateTime ( A date-time without a time-zone ), when doing the conversion. > Also, it might be helpful if the user can set the user timezone in Beeline > session, lets say "user.timezone”, which should be honored while showing the > beeline output of a particular timestamp field. > > This issue is also more pronounced because of this bug in Java -> > [https://bugs.java.com/bugdatabase/view_bug.do?bug_id=JDK-8258586] . -- This message was sent by Atlassian Jira (v8.3.4#803005)