[
https://issues.apache.org/jira/browse/HIVE-21643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16824191#comment-16824191
]
Thai Bui commented on HIVE-21643:
---------------------------------
Note that this problem is quite serious. Essentially, Hive 3 is
non-backwarrds-compatible when it comes to parsing datetime with timezones.
[~rajkamalmn] I think if you rename the patch to "Hive-21643.01.patch" and
reupload then Hive QA will pick up the patch and run all the tests.
> Fix Broken support for ISO Time with Zone in Hive UDFs
> ------------------------------------------------------
>
> Key: HIVE-21643
> URL: https://issues.apache.org/jira/browse/HIVE-21643
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Affects Versions: 3.0.0, 3.1.0, 3.1.1
> Reporter: RAJKAMAL
> Priority: Minor
> Labels: pull-request-available
> Attachments: HIVE-21643.1.patch
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> The followings UDFs date_format and to_date used to support ISO dates with
> timezone and the support has been broken since Hive 3.x release.
> Example:
> date_format('2017-03-16T00:10:42Z', 'y')
> date_format('2017-03-16T00:10:42+01:00', 'y')
> date_format('2017-03-16T00:10:42-01:00', 'y')
> to_date('2015-04-11T01:30:45Z')
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
