[
https://issues.apache.org/jira/browse/HIVE-20385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16618357#comment-16618357
]
Ashutosh Chauhan commented on HIVE-20385:
-----------------------------------------
[~bpusztahazi] Return type for date + int (or date - int) should be date and
not timestamp.
Yes, we need to rerun the tests to get a clean run before we can push this
change in.
> Date: date + int fails to add days
> ----------------------------------
>
> Key: HIVE-20385
> URL: https://issues.apache.org/jira/browse/HIVE-20385
> Project: Hive
> Issue Type: Bug
> Components: Types
> Affects Versions: 4.0.0
> Reporter: Gopal V
> Assignee: Bruno Pusztahazi
> Priority: Minor
> Attachments: HIVE-20385.1.patch
>
>
> {code}
> select current_date + 5;
> FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments '5': No
> matching method for class
> org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPDTIPlus with (date, int)
> {code}
> This works in Postgres 9.6 - http://sqlfiddle.com/#!17/9eecb/19253/0
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
