[
https://issues.apache.org/jira/browse/HIVE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Namitha Babychan reassigned HIVE-3299:
--------------------------------------
Assignee: Carl Steinbach (was: Namitha Babychan)
> UDF DAYNAME(date) to HIVE
> ---------------------------
>
> 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: Carl Steinbach
> Labels: patch
> Attachments: HIVE-3299.1.patch.txt, Hive-3299_Testcase.doc,
> udf_dayname.q, udf_dayname.q.out
>
>
> Current releases of Hive lacks a function which would return the day name
> corresponding to a date / timestamp value which might be a part of a column.
>
> The function -DAYNAME (date) would return the day name from a date /
> timestamp or column which would be useful while using HiveQL. This would find
> its use in various business sectors like retail, which would help in
> identifying the trends and sales datails for a particular weekday for entire
> year,month or week.
> Functionality :-
> Function Name: DAYNAME (date)
>
> Returns the name of the weekday for date.
> Example: hive> SELECT DAYNAME('2012-07-25');
> -> 'Wednesday'
> Usage :-
> Case 1 : To find DAY NAME corresponding to a particular date
> hive> SELECT DAYNAME('2012-07-25');
> -> 'Wednesday'
> Case 2 : To query a table to find details based on a particular day name
> Table :-
> date |item id|store id |value|unit|price
> 01/07/2012|110001|0011111111003|0.99|1.00|0.99
> 02/07/2012|110001|0011111111008|0.99|0.00|0.00
> 03/07/2012|110001|0011111111009|0.99|0.00|0.00
> 04/07/2012|110001|0011111112002|0.99|0.00|0.00
> 05/07/2012|110001|0011111112003|0.99|0.00|0.00
> 06/07/2012|110001|0011111112006|0.99|1.00|0.99
> 07/07/2012|110001|0011111112007|0.99|0.00|0.00
> 08/07/2012|110001|0011111112008|0.99|0.00|0.00
> 09/07/2012|110001|0011111112009|0.99|0.00|0.00
> 10/07/2012|110001|0011111112010|0.99|0.00|0.00
> 11/07/2012|110001|0011111113003|0.99|0.00|0.00
> 12/07/2012|110001|0011111113006|0.99|0.00|0.00
> 13/07/2012|110001|0011111113008|0.99|0.00|0.00
> 14/07/2012|110001|0011111113010|0.99|0.00|0.00
> 15/07/2012|110001|0011111114002|0.99|0.00|0.00
> 16/07/2012|110001|0011111114004|0.99|1.00|0.99
> 17/07/2012|110001|0011111114005|0.99|0.00|0.00
> 18/07/2012|110001|0011111121004|0.99|0.00|0.00
> Query : select * from sales where dayname(date)='wednesday';
> Result :-
> 04/07/2012|110001|0011111112002|0.99|0.00|0.00
> 11/07/2012|110001|0011111113003|0.99|0.00|0.00
> 18/07/2012|110001|0011111121004|0.99|0.00|0.00
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
