[ https://issues.apache.org/jira/browse/HIVE-9480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14330000#comment-14330000 ]
Hive QA commented on HIVE-9480: ------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12699997/HIVE-9480.7.patch {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 7575 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_groupby3_map org.apache.hive.jdbc.TestMultiSessionsHS2WithLocalClusterSpark.testSparkQuery {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2840/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2840/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2840/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12699997 - 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-9480.7.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)