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

Hive divide operator generates wrong results in certain cases

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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.patch
          17 kB
          Xuefu Zhang
        2. HIVE-5866.1.patch
          30 kB
          Xuefu Zhang
        3. HIVE-5866.2.patch
          496 kB
          Xuefu Zhang
        4. HIVE-5866.3.patch
          511 kB
          Xuefu Zhang
        5. HIVE-5866.4.patch
          513 kB
          Xuefu Zhang

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment