[jira] [Created] (HIVE-5996) Query for sum of a long column of a table with only two rows produces wrong result

["Xuefu Zhang (JIRA)" <ji...@apache.org>]

Xuefu Zhang created HIVE-5996:
---------------------------------

             Summary: Query for sum of a long column of a table with only two rows produces wrong result
                 Key: HIVE-5996
                 URL: https://issues.apache.org/jira/browse/HIVE-5996
             Project: Hive
          Issue Type: Bug
          Components: UDF
    Affects Versions: 0.12.0
            Reporter: Xuefu Zhang
            Assignee: Xuefu Zhang


{quote}
hive> desc test2;
OK
l                   	bigint              	None                
hive> select * from test2;                                 
OK
6666666666666666666
5555555555555555555
hive> select sum(l) from test2;
OK
-6224521851487329395
{quote}
It's believed that a wrap-around error occurred. It's surprising that it happens only with two rows. Same query in MySQL returns:
{quote}
mysql> select sum(l) from test;
+----------------------+
| sum(l)               |
+----------------------+
| 12222222222222222221 |
+----------------------+
1 row in set (0.00 sec)
{quote}
Hive should accommodate large number of rows. Overflowing with only two rows is very unusable.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)