hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bennie Schut (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3299) Create UDF DAYNAME(date)
Date Sun, 19 Apr 2015 08:26:58 GMT

    [ 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)

Mime
View raw message