[HIVE-25950] unix_timestamp returns NULL for incomplete date

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: Clients, UDF
• Labels: timestamp
• Assignee: Rishikesh Mohanty
• Reporter: roxxette
• Created: 11/Feb/22 02:54
• Updated: 24/May/22 12:01

Description

select from_unixtime(unix_timestamp('202202', 'yyyyMM'), 'yyyyMMdd');

returns 20220201 in HDI3.6(Hive1.2.1)

returns NULL in HDI4.0(Hive3.1.0)

 

Turns out Hive 1.2.1 has default value for year(1970), month(01), day(01).

And Hive 3.1.0 doesn't.

 

So in Hive 3.1.0 we have to parse a date with all 3 parts(y/m/d), otherwise it'll fail.