[
https://issues.apache.org/jira/browse/HIVE-20385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16580161#comment-16580161
]
Gopal V commented on HIVE-20385:
--------------------------------
The immediate workaround is to disambiguate the operation by specifying "days".
{code}
hive> select current_date +5 days ;
OK
2018-08-19 00:00:00
{code}
> 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
> Priority: Major
>
> {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)