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

Joins on decimal keys return different results whether they are run as reduce join or map join

    XMLWordPrintableJSON

    Details

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

      Description

      See attached .q file to reproduce. The difference seems to be whether trailing 0s are considered the same value or not.

        Attachments

        1. join_test.q
          0.8 kB
          Gunther Hagleitner
        2. HIVE-8745.3.patch
          203 kB
          Jason Dere
        3. HIVE-8745.2.patch
          101 kB
          Jason Dere
        4. HIVE-8745.1.patch
          37 kB
          Jason Dere

          Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-7373 Hive should not remove trailing zeros for decimal numbers

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-8796 TestCliDriver acid tests with decimal needs benchmark to be updated

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. HIVE-8724 Right outer join produces incorrect result on Tez

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link https://reviews.apache.org/r/27715/

            Activity

              People

              • Assignee:
                jdere Jason Dere
                Reporter:
                hagleitn Gunther Hagleitner
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: