[ https://issues.apache.org/jira/browse/HIVE-9480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14309878#comment-14309878 ]
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/12696904/HIVE-9480.4.patch {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 7487 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_sortmerge_join_2 org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testMetastoreProxyUser org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testSaslWithHiveMetaStore {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2687/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2687/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2687/ 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: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12696904 - 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 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-01-12', 'MM') FROM src LIMIT 1; > will return 2009-01-01 > BTW, this TRUNC is not as feature complete as aligned with Oracle one. 'MM' > is the only format supported, however, it's a base to add on other formats. -- This message was sent by Atlassian JIRA (v6.3.4#6332)