[jira] [Commented] (HIVE-21643) Fix Broken support for ISO Time with Zone in Hive UDFs

2021-05-13 Thread Bradley Peterson (Jira) 


[ 
https://issues.apache.org/jira/browse/HIVE-21643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17344093#comment-17344093
 ] 

Bradley Peterson commented on HIVE-21643:
-

This PR was closed without review. Is there any plan to support parsing ISO 
timestamps with timezone in Hive 3.1?

> 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.1.0, 3.0.0, 3.1.1
>Reporter: RAJKAMAL
>Assignee: Navya Sruthi Sunkarapalli
>Priority: Major
>  Labels: patch-available, pull-request-available
> Attachments: HIVE-21643.1.patch, Hive-21643.01.patch
>
>  Time Spent: 0.5h
>  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
(v8.3.4#803005)

[jira] [Commented] (HIVE-21643) Fix Broken support for ISO Time with Zone in Hive UDFs

2019-06-04 Thread RAJKAMAL (JIRA) 


[ 
https://issues.apache.org/jira/browse/HIVE-21643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16856083#comment-16856083
 ] 

RAJKAMAL commented on HIVE-21643:
-

[~Rajkumar Singh] Will you be able to look at the patch ?

> 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
>Assignee: Navya Sruthi Sunkarapalli
>Priority: Major
>  Labels: patch-available, pull-request-available
> Attachments: HIVE-21643.1.patch, Hive-21643.01.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)

[jira] [Commented] (HIVE-21643) Fix Broken support for ISO Time with Zone in Hive UDFs

2019-05-21 Thread RAJKAMAL (JIRA) 


[ 
https://issues.apache.org/jira/browse/HIVE-21643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16845503#comment-16845503
 ] 

RAJKAMAL commented on HIVE-21643:
-

cc: [~Rajkumar Singh] I see a related ticket comment on 
https://issues.apache.org/jira/browse/HIVE-21743

 

> 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
>Assignee: Navya Sruthi Sunkarapalli
>Priority: Major
>  Labels: patch-available, pull-request-available
> Attachments: HIVE-21643.1.patch, Hive-21643.01.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)

[jira] [Commented] (HIVE-21643) Fix Broken support for ISO Time with Zone in Hive UDFs

2019-04-29 Thread RAJKAMAL (JIRA) 


[ 
https://issues.apache.org/jira/browse/HIVE-21643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16829915#comment-16829915
 ] 

RAJKAMAL commented on HIVE-21643:
-

[~NavyaS] Can you please look at the patch ? Also let me know, if you need more 
information for the patch.

> 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
>Assignee: Navya Sruthi Sunkarapalli
>Priority: Major
>  Labels: patch-available, pull-request-available
> Attachments: HIVE-21643.1.patch, Hive-21643.01.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)

[jira] [Commented] (HIVE-21643) Fix Broken support for ISO Time with Zone in Hive UDFs

2019-04-23 Thread Thai Bui (JIRA) 


[ 
https://issues.apache.org/jira/browse/HIVE-21643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)

[jira] [Commented] (HIVE-21643) Fix Broken support for ISO Time with Zone in Hive UDFs

2019-04-22 Thread RAJKAMAL (JIRA) 


[ 
https://issues.apache.org/jira/browse/HIVE-21643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16823607#comment-16823607
 ] 

RAJKAMAL commented on HIVE-21643:
-

[~jcamachorodriguez] Can you please look at the patch ?

> 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
> Attachments: HIVE-21643.1.patch
>
>
> 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)