[jira] [Commented] (HIVE-345) Extend Date UDFs to support time zone and full specs as in MySQL

["Naveen Kumar Mahadevuni (JIRA)" <ji...@apache.org>]

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

Naveen Kumar Mahadevuni commented on HIVE-345:
----------------------------------------------

Hi. I'm starting as a contributor. I would like to work on this. Is anyone else working on similar changes? HIVE-6009, HIVE-2867 and HIVE-6040 are also related to this. 

> Extend Date UDFs to support time zone and full specs as in MySQL
> ----------------------------------------------------------------
>
>                 Key: HIVE-345
>                 URL: https://issues.apache.org/jira/browse/HIVE-345
>             Project: Hive
>          Issue Type: Improvement
>          Components: UDF
>    Affects Versions: 0.3.0
>            Reporter: Zheng Shao
>            Assignee: Mark Grover
>
> Most of the Date UDF in Hive now are based on String instead of Date objects, and they have limited functionality compared with MySQL.
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-sub
> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_datediff
> We should make it fully compliant with what MySQL offers.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)