You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "shalish (JIRA)" <ji...@apache.org> on 2012/07/25 13:03:35 UTC
[jira] [Updated] (HIVE-3299) UDF DAYNAME(date) to HIVE
[ https://issues.apache.org/jira/browse/HIVE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
shalish updated HIVE-3299:
--------------------------
Description:
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
was:
Function Name: DAYNAME (date)
Returns the name of the weekday for date.
Example: hive> SELECT DAYNAME('2012-07-25');
-> 'Wednesday'
> 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
>
>
> 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