[HIVE-345] Extend Date UDFs to support time zone and full specs as in MySQL - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: 0.3.0
Fix Version/s: None
Component/s: UDF
Labels:
None

Description

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.

Attachments

Issue Links

depends upon

HIVE-313 add UDF date_add, date_sub, datediff

Closed

relates to

HIVE-1269 Support Date/Datetime/Time/Timestamp Primitive Types

Open

Activity

People

Assignee:: Unassigned

Reporter:: Zheng Shao

Votes:: 1 Vote for this issue

Watchers:: 9 Start watching this issue

Dates

Created:: 12/Mar/09 07:04

Updated:: 08/Apr/17 19:51