You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Varun Gullipalli (JIRA)" <ji...@apache.org> on 2016/07/15 20:10:21 UTC

[jira] [Created] (HIVE-14252) Sum on Decimal rounding provides incorrect result

Varun Gullipalli created HIVE-14252:
---------------------------------------

             Summary: Sum on Decimal rounding provides incorrect result
                 Key: HIVE-14252
                 URL: https://issues.apache.org/jira/browse/HIVE-14252
             Project: Hive
          Issue Type: Bug
            Reporter: Varun Gullipalli


hive> select sum(round(amt, 2)), sum(round(txn_amt, 2)) from table1  where DT ='20160517'    
union all
select sum(round(amt,2)), sum(round(txn_amt,2)) from table 2
where DT ='20160517'   

99773.57999999997       77408.35
3336.1699999999996      2582.3500000000013




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)