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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: