[ https://issues.apache.org/jira/browse/HIVE-5810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13830792#comment-13830792 ]
Hive QA commented on HIVE-5810: ------------------------------- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12615476/HIVE-5810.2.patch {color:green}SUCCESS:{color} +1 4684 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/425/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/425/console 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: 12615476 > 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.2.patch, 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)