hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <>
Subject [jira] [Commented] (HIVE-9480) Build UDF TRUNC to implement FIRST_DAY as compared with LAST_DAY
Date Thu, 26 Feb 2015 03:21:04 GMT


Hive QA commented on HIVE-9480:

{color:green}Overall{color}: +1 all checks pass

Here are the results of testing the latest attachment:

{color:green}SUCCESS:{color} +1 7576 tests passed

Test results:
Console output:
Test logs:

Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase

This message is automatically generated.

ATTACHMENT ID: 12700903 - PreCommit-HIVE-TRUNK-Build

> Build UDF TRUNC to implement FIRST_DAY as compared with LAST_DAY
> ----------------------------------------------------------------
>                 Key: HIVE-9480
>                 URL:
>             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

View raw message