[HIVE-17038] invalid result when CAST-ing to DATE

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.2.1
• Component/s: CLI, Hive
• Labels: pull-request-available
• Assignee: Ashish Sharma
• Reporter: Jim Hopper
• Created: 05/Jul/17 12:07
• Updated: 26/Jul/21 05:05
• Resolved: 26/Jul/21 05:05

Description

when casting incorrect date literals to DATE data type hive returns wrong values instead of NULL.

SELECT CAST('2017-02-31' AS DATE);
SELECT CAST('2017-04-31' AS DATE);

Some examples below where it really can produce weird results:

select *
  from (
select cast('2017-07-01' as date) as dt
) as t
where t.dt = '2017-06-31';

select *
  from (
select cast('2017-07-01' as date) as dt
) as t
where t.dt = cast('2017-06-31' as date);

Issue Links

• is related to: HIVE-25306 Change Date/Timestamp parser from LENIENT to STRICT
• links to: GitHub Pull Request #204
• links to: GitHub Pull Request #204