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

Hive divide operator generates wrong results in certain cases

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.13.0
    • 0.13.0
    • None
    • None

    Description

      Current GenericUDFOPDivide seems having a bug. The following query generates NULL result.

      hive> select 4BD / 25BD  from test limit 1;        
...
Total MapReduce CPU Time Spent: 890 msec
OK
NULL
Time taken: 7.901 seconds, Fetched: 1 row(s)

      The correct result should be 0.16 in this query.

      Attachments

        1. HIVE-5866.1.patch
          30 kB
          Xuefu Zhang
        2. HIVE-5866.2.patch
          496 kB
          Xuefu Zhang
        3. HIVE-5866.3.patch
          511 kB
          Xuefu Zhang
        4. HIVE-5866.4.patch
          513 kB
          Xuefu Zhang
        5. HIVE-5866.patch
          17 kB
          Xuefu Zhang

        Issue Links

          is depended upon by

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5872 Make UDAFs such as GenericUDAFSum report accurate precision/scale for decimal types

          • Major - Major loss of function.
          • Resolved
          is part of

          New Feature - A new feature of the product, which has yet to be developed. HIVE-3976 Support specifying scale and precision with Hive decimal type

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

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

          Activity

            People

              xuefuz Xuefu Zhang
              xuefuz Xuefu Zhang
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: