Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-17038

invalid result when CAST-ing to DATE

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 1.2.1
    • None
    • CLI, Hive

    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);

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-25306 Change Date/Timestamp parser from LENIENT to STRICT

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #204

          Web Link GitHub Pull Request #204

          Activity

            People

              ashish-kumar-sharma Ashish Sharma
              hopperjim Jim Hopper
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m