You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Sanam Naz (JIRA)" <ji...@apache.org> on 2012/08/23 06:02:42 UTC
[jira] [Created] (HIVE-3404) Hive current releases lacks a function
which returns the numeric day of an year if a date or timestamp is given.
Sanam Naz created HIVE-3404:
-------------------------------
Summary: Hive current releases lacks a function which returns the numeric day of an year if a date or timestamp is given.
Key: HIVE-3404
URL: https://issues.apache.org/jira/browse/HIVE-3404
Project: Hive
Issue Type: New Feature
Components: UDF
Reporter: Sanam Naz
--
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
[jira] [Updated] (HIVE-3404) Hive current releases lacks a function
which returns the quarter of an year if a date or timestamp is given .
Posted by "Sanam Naz (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sanam Naz updated HIVE-3404:
----------------------------
Description: Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .The function QUARTER(date) would return the quarter from a date / timestamp .This can be used in HiveQL.This will be useful for different domains like retail ,finance etc.
> Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .
> -------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-3404
> URL: https://issues.apache.org/jira/browse/HIVE-3404
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Sanam Naz
>
> Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .The function QUARTER(date) would return the quarter from a date / timestamp .This can be used in HiveQL.This will be useful for different domains like retail ,finance etc.
--
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
[jira] [Updated] (HIVE-3404) UDF to obtain the quarter of an year
if a date or timestamp is given .
Posted by "Archana Nair (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Archana Nair updated HIVE-3404:
-------------------------------
Attachment: HIVE-3404.1.patch.txt
patch for the HIVE-3404 is available in the file HIVE-3404.1.patch.
> UDF to obtain the quarter of an year if a date or timestamp is given .
> ----------------------------------------------------------------------
>
> Key: HIVE-3404
> URL: https://issues.apache.org/jira/browse/HIVE-3404
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Sanam Naz
> Attachments: HIVE-3404.1.patch.txt
>
>
> Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .The function QUARTER(date) would return the quarter from a date / timestamp .This can be used in HiveQL.This will be useful for different domains like retail ,finance etc.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3404) UDF to obtain the quarter of an year
if a date or timestamp is given .
Posted by "Archana Nair (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Archana Nair updated HIVE-3404:
-------------------------------
Summary: UDF to obtain the quarter of an year if a date or timestamp is given . (was: Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .)
> UDF to obtain the quarter of an year if a date or timestamp is given .
> ----------------------------------------------------------------------
>
> Key: HIVE-3404
> URL: https://issues.apache.org/jira/browse/HIVE-3404
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Sanam Naz
>
> Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .The function QUARTER(date) would return the quarter from a date / timestamp .This can be used in HiveQL.This will be useful for different domains like retail ,finance etc.
--
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
[jira] [Updated] (HIVE-3404) Hive current releases lacks a function
which returns the quarter of an year if a date or timestamp is given .
Posted by "Sanam Naz (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sanam Naz updated HIVE-3404:
----------------------------
Summary: Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given . (was: Hive current releases lacks a function which returns the numeric day of an year if a date or timestamp is given.)
> Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .
> -------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-3404
> URL: https://issues.apache.org/jira/browse/HIVE-3404
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Sanam Naz
>
--
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
[jira] [Commented] (HIVE-3404) UDF to obtain the quarter of an year
if a date or timestamp is given .
Posted by "Deepti Antony (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13440127#comment-13440127 ]
Deepti Antony commented on HIVE-3404:
-------------------------------------
We can add a UDF which will return the quarter in which a particular date lies.
Case 1 : hive> SELECT QUARTER ('2011-02-18')FROM TABLE_NAME ;
> 1
Case 2: hive > SELECT * FROM TABLE_NAME WHERE QUARTER (date) = 2;
date|store_id|unit|value|price
2010-10-12 |11001|3|5.00|15.00
2011-02-18 |12001|4|6.00|24.00
2000-04-19 |11002|6|1.00|6.00
2012-05-21 |11002|8|1.00|8.00
2004-12-31|11003|2|3.00|6.00
RESULT:
2000-04-19 |11002|6|1.00|6.00
2012-05-21 |11002|8|1.00|8.00
> UDF to obtain the quarter of an year if a date or timestamp is given .
> ----------------------------------------------------------------------
>
> Key: HIVE-3404
> URL: https://issues.apache.org/jira/browse/HIVE-3404
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Sanam Naz
>
> Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .The function QUARTER(date) would return the quarter from a date / timestamp .This can be used in HiveQL.This will be useful for different domains like retail ,finance etc.
--
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
[jira] [Updated] (HIVE-3404) UDF to obtain the quarter of an year
if a date or timestamp is given .
Posted by "Archana Nair (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Archana Nair updated HIVE-3404:
-------------------------------
Status: Patch Available (was: Open)
> UDF to obtain the quarter of an year if a date or timestamp is given .
> ----------------------------------------------------------------------
>
> Key: HIVE-3404
> URL: https://issues.apache.org/jira/browse/HIVE-3404
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Sanam Naz
> Attachments: HIVE-3404.1.patch.txt
>
>
> Hive current releases lacks a function which returns the quarter of an year if a date or timestamp is given .The function QUARTER(date) would return the quarter from a date / timestamp .This can be used in HiveQL.This will be useful for different domains like retail ,finance etc.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira