[HIVE-12502] to_date UDF cannot accept NULLs of VOID type

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.3.0, 2.1.0
• Component/s: UDF
• Assignee: Aaron Tokhy
• Reporter: Aaron Tokhy
• Created: 24/Nov/15 01:20
• Updated: 21/Jun/16 15:53
• Resolved: 05/Jan/16 01:16

Description

The to_date method behaves differently based off the 'data type' of null passed in.

hive> select to_date(null);
FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments 'TOK_NULL': TO_DATE() only takes STRING/TIMESTAMP/DATEWRITABLE types, got VOID

hive> select to_date(cast(null as timestamp));
OK
NULL
Time taken: 0.031 seconds, Fetched: 1 row(s)

This appears to be a regression introduced in HIVE-5731. The previous version of to_date would not check the type:

https://github.com/apache/hive/commit/09b6553214d6db5ec7049b88bbe8ff640a7fef72#diff-204f5588c0767cf372a5ca7e3fb964afL56

Issue Links

• is related to: HIVE-5731 Use new GenericUDF instead of basic UDF for UDFDate* classes