[
https://issues.apache.org/jira/browse/HIVE-9480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14329948#comment-14329948
]
Hive QA commented on HIVE-9480:
-------------------------------
{color:green}Overall{color}: +1 all checks pass
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12699980/HIVE-9480.6.patch
{color:green}SUCCESS:{color} +1 7572 tests passed
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2838/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2838/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2838/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12699980 - PreCommit-HIVE-TRUNK-Build
> 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 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)
