Hive
  1. Hive
  2. HIVE-7067

Min() and Max() on Timestamp and Date columns for ORC returns wrong results

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.14.0, 0.13.1
    • Component/s: None
    • Labels:
      None

      Description

      min() and max() of timestamp and date columns of ORC table returns wrong results. The reason for that is when ORC creates object inspectors for date and timestamp it uses JAVA primitive objects as opposed to WRITABLE objects. When get() is performed on java primitive objects, a reference to the underlying object is returned whereas when get() is performed on writable objects, a copy of the underlying object is returned.

      Fix is to change the object inspector creation to return writable objects for timestamp and date.

      1. HIVE-7067.branch-13.2.patch
        31 kB
        Prasanth Jayachandran
      2. HIVE-7067.2.patch
        31 kB
        Prasanth Jayachandran
      3. HIVE-7067.1.patch
        28 kB
        Prasanth Jayachandran

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Prasanth Jayachandran
              Reporter:
              Prasanth Jayachandran
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development