[ https://issues.apache.org/jira/browse/HIVE-9396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14280570#comment-14280570 ]
Sergio Peña commented on HIVE-9396: ----------------------------------- hi [~jdere] Are you working on this issue? If not, I'd like to assign it to myself. > 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 > > {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)