[ https://issues.apache.org/jira/browse/HIVE-5810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13829413#comment-13829413 ]
Hive QA commented on HIVE-5810: ------------------------------- {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/12615080/HIVE-5810.patch {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 4680 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_show_functions {noformat} Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/388/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/388/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests failed with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12615080 > create a function add_date as exists in mysql > ------------------------------------------------ > > Key: HIVE-5810 > URL: https://issues.apache.org/jira/browse/HIVE-5810 > Project: Hive > Issue Type: Improvement > Reporter: Anandha L Ranganathan > Assignee: Anandha L Ranganathan > Attachments: HIVE-5810.patch > > Original Estimate: 40h > Remaining Estimate: 40h > > MySQL has ADDDATE(date,INTERVAL expr unit). > Similarly in Hive we can have (date,unit,expr). > Here Unit is DAY/Month/Year > For example, > add_date('2013-11-09','DAY',2) will return 2013-11-11. > add_date('2013-11-09','Month',2) will return 2014-01-09. > add_date('2013-11-09','Year',2) will return 2014-11-11. -- This message was sent by Atlassian JIRA (v6.1#6144)