[ 
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sergio Peña updated HIVE-9396:
------------------------------
    Attachment: HIVE-9396.3.patch

> date_add()/date_sub() should allow tinyint/smallint/bigint arguments in 
> addition to int
> ---------------------------------------------------------------------------------------
>
>                 Key: HIVE-9396
>                 URL: https://issues.apache.org/jira/browse/HIVE-9396
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>            Reporter: Jason Dere
>            Assignee: Sergio Peña
>         Attachments: HIVE-9396.3.patch
>
>
> {noformat}
> hive> select c1, date_add('1985-01-01', c1) from short1;
> FAILED: SemanticException [Error 10014]: Line 1:11 Wrong arguments 'c1':  
> DATE_ADD() only takes INT types as second  argument, got SHORT
> {noformat}
> We should allow date_add()/date_sub() to take any integral type for the 2nd 
> argument, rather than just int.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to