hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Pivovarov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-3404) Create quarter UDF
Date Fri, 24 Apr 2015 22:24:38 GMT

     [ https://issues.apache.org/jira/browse/HIVE-3404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexander Pivovarov updated HIVE-3404:
--------------------------------------
    Description: 
The function QUARTER(date) would return the quarter  from a string / date / timestamp. 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.

MySQL has QUARTER function
https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_quarter


> Create quarter UDF
> ------------------
>
>                 Key: HIVE-3404
>                 URL: https://issues.apache.org/jira/browse/HIVE-3404
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>            Reporter: Sanam Naz
>            Assignee: Alexander Pivovarov
>         Attachments: HIVE-3404.1.patch.txt
>
>
> The function QUARTER(date) would return the quarter  from a string / date / timestamp.
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)

Mime
View raw message