[
https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14280953#comment-14280953
]
Jason Dere commented on HIVE-9396:
----------------------------------
Oh, hadn't thought about the bigint case .. I would say just remove the bigint
handling from the UDF, makes things a bit simpler. They can cast that if they
need it.
> 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.1.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)
