[HIVE-23752] Cast as Date for invalid date produce the valid output

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 4.0.0
• Component/s: Hive
• Labels: hive
• Assignee: Ashish Sharma
• Reporter: Rajkumar Singh
• Created: 23/Jun/20 22:08
• Updated: 26/Jul/21 05:06
• Resolved: 26/Jul/21 05:06

Description

Hive-3:

select cast("0000-00-00" as date) 
0002-11-30 

select cast("2010-27-54" as date)
 2012-04-23

select cast("1992-00-74" as date) ;
1992-02-12

The reason Hive allowing is because Parser formatted is set to LENIENT https://github.com/apache/hive/blob/ae008b79b5d52ed6a38875b73025a505725828eb/common/src/java/org/apache/hadoop/hive/common/type/Date.java#L50, this seems to be an intentional change as changing the ResolverStyle to STRICT start failing the tests.

Issue Links

• is related to: HIVE-25306 Change Date/Timestamp parser from LENIENT to STRICT