You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Xiaobing Zhou (JIRA)" <ji...@apache.org> on 2015/02/26 00:38:04 UTC

[jira] [Updated] (HIVE-9480) Build UDF TRUNC to implement FIRST_DAY as compared with LAST_DAY

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

Xiaobing Zhou updated HIVE-9480:
--------------------------------
    Attachment: HIVE-9480.8.patch

patch V8. Can you again review it [~apivovarov]? Thanks.

> Build UDF TRUNC to implement FIRST_DAY as compared with LAST_DAY
> ----------------------------------------------------------------
>
>                 Key: HIVE-9480
>                 URL: https://issues.apache.org/jira/browse/HIVE-9480
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>    Affects Versions: 0.14.0
>            Reporter: Xiaobing Zhou
>            Assignee: Xiaobing Zhou
>         Attachments: HIVE-9480.1.patch, HIVE-9480.3.patch, HIVE-9480.4.patch, HIVE-9480.5.patch, HIVE-9480.6.patch, HIVE-9480.7.patch, HIVE-9480.8.patch
>
>
> Hive already supports LAST_DAY UDF, in some cases, FIRST_DAY is necessary to do date/timestamp related computation. This JIRA is to track such an implementation. Choose to impl TRUNC, a more standard way to get the first day of a a month, e.g., SELECT TRUNC('2009-12-12', 'MM'); will return 2009-12-01, SELECT TRUNC('2009-12-12', 'YEAR'); will return 2009-01-01.
> BTW, this TRUNC is not as feature complete as aligned with Oracle one. only 'MM' and 'YEAR' are supported as format, however, it's a base to add on other formats.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)