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

Bennie Schut commented on HIVE-3299:
------------------------------------

I would like you to reconsider adding this patch. Historically we add 
functionality similar to mysql and this function is available in mysql: 
https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_dayname
Now granted we can easily workaround it but that would mean we stop taking 
mysql as our target.

> Create UDF  DAYNAME(date)
> -------------------------
>
>                 Key: HIVE-3299
>                 URL: https://issues.apache.org/jira/browse/HIVE-3299
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>    Affects Versions: 0.9.0
>            Reporter: Namitha Babychan
>            Assignee: Alexander Pivovarov
>              Labels: patch
>         Attachments: HIVE-3299.1.patch.txt, HIVE-3299.2.patch, 
> HIVE-3299.3.patch, HIVE-3299.4.patch, HIVE-3299.5.patch, HIVE-3299.patch.txt, 
> Hive-3299_Testcase.doc, udf_dayname.q, udf_dayname.q.out
>
>
> dayname(date/timestamp/string)
> Returns the name of the weekday for date. The language used for the name is 
> English.
> select dayname('2015-04-08');
> Wednesday



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

Reply via email to