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)

Reply via email to