[
https://issues.apache.org/jira/browse/HIVE-20385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16620245#comment-16620245
]
Gopal V commented on HIVE-20385:
--------------------------------
[~kgyrtkirk]: Agree (date+int) is the only safe one to do. Timestamp math is
dangerous because Hive has a bit of bad history there hidden behind a config
var (hive.int.timestamp.conversion.in.seconds)
> 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)
