[ 
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)

Reply via email to