[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14292511#comment-14292511
]
Lefty Leverenz commented on HIVE-9396:
--------------------------------------
Doc note: This should be documented, with release information and a link back
to this issue, in the Date Functions section of the UDF wikidoc.
* [Hive Operators and UDFs -- Date Functions |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions]
> 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
> Labels: TODOC15
> Fix For: 0.15.0
>
> Attachments: HIVE-9396.3.patch, HIVE-9396.4.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)
