You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zoltan Haindrich (JIRA)" <ji...@apache.org> on 2018/09/19 07:36:00 UTC
***UNCHECKED*** [jira] [Commented] (HIVE-20385) Date: date + int
fails to add days
[ https://issues.apache.org/jira/browse/HIVE-20385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16620238#comment-16620238 ]
Zoltan Haindrich commented on HIVE-20385:
-----------------------------------------
I don't think it would be desireable to start interpreting TIMESTAMP+INT ; I feel that without specifying the unit the result of it is somewhat undefined...
> 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)