hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "shalish (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3299) UDF DAYNAME(date) to HIVE
Date Wed, 25 Jul 2012 10:57:34 GMT

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

shalish commented on HIVE-3299:
-------------------------------

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
                
> 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
>             Fix For: 0.10.0
>
>
> Function Name: DAYNAME (date)
> 	 
> Returns the name of the weekday for date. 
> Example: hive> SELECT DAYNAME('2012-07-25');
>                    -> 'Wednesday'

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

        

Mime
View raw message