[
https://issues.apache.org/jira/browse/HIVE-5866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13830511#comment-13830511
]
Jason Dere commented on HIVE-5866:
----------------------------------
Ok, I understand the issue now - the integer portion of the result type was
(7,6) so only 1 integer digit, and trying to cast both operands to decimal(7,6)
which would result in null for 24.
Changes look good, left a comment on RB.
> Hive divide operator generates wrong results in certain cases
> -------------------------------------------------------------
>
> Key: HIVE-5866
> URL: https://issues.apache.org/jira/browse/HIVE-5866
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.13.0
> Reporter: Xuefu Zhang
> Assignee: Xuefu Zhang
> Attachments: HIVE-5866.1.patch, HIVE-5866.2.patch, HIVE-5866.patch
>
>
> Current GenericUDFOPDivide seems having a bug. The following query generates
> NULL result.
> {code}
> 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)
> {code}
> The correct result should be 0.16 in this query.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
