You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Alexander Pivovarov (JIRA)" <ji...@apache.org> on 2015/04/24 21:55:38 UTC
[jira] [Updated] (HIVE-3404) UDF to obtain the quarter of an year
if a date or timestamp is given .
[ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexander Pivovarov 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.
MySQL has QUARTER function
https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_quarter
was: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.
> 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.
> MySQL has QUARTER function
> https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_quarter
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)