[ 
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

        

Reply via email to