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: Hadoop Hive Issue Type: Improvement Components: Query Processor Affects Versions: 0.3.0 Reporter: Zheng Shao 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 is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.