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

Posted to dev@hive.apache.org by "Ashish Sharma (Jira)" <ji...@apache.org> on 2021/09/29 12:21:00 UTC

[jira] [Created] (HIVE-25576) Raise exception instead of silent change for new DateFormatter

Ashish Sharma created HIVE-25576:
------------------------------------

             Summary: Raise exception instead of silent change for new DateFormatter
                 Key: HIVE-25576
                 URL: https://issues.apache.org/jira/browse/HIVE-25576
             Project: Hive
          Issue Type: Improvement
    Affects Versions: 4.0.0
            Reporter: Ashish Sharma
            Assignee: Ashish Sharma


*Hive 1.2* - 

VM time zone set to Asia/Bangkok

Query - SELECT FROM_UNIXTIME(UNIX_TIMESTAMP('1800-01-01 00:00:00 UTC','yyyy-MM-dd HH:mm:ss z'));

Result - 1800-01-01 07:00:00

*Master branch* - 

set hive.local.time.zone=Asia/Bangkok;

Query - SELECT FROM_UNIXTIME(UNIX_TIMESTAMP('1800-01-01 00:00:00 UTC','yyyy-MM-dd HH:mm:ss z'));

Result - 1800-01-01 06:42:04






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