[HIVE-9396] date_add()/date_sub() should allow tinyint/smallint/bigint arguments in addition to int

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: UDF
• Labels: TODOC15
• Assignee: Sergio Peña
• Reporter: Jason Dere
• Created: 16/Jan/15 09:31
• Updated: 12/Feb/15 23:40
• Resolved: 26/Jan/15 19:25

Description

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

We should allow date_add()/date_sub() to take any integral type for the 2nd argument, rather than just int.