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

2013-12-13 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13847381#comment-13847381 ] Thejas M Nair commented on HIVE-5996: - Sorry, I meant even if the input row type is

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

2013-12-13 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13847579#comment-13847579 ] Xuefu Zhang commented on HIVE-5996: --- Yes, in theory, but unlikely. Current precision

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

2013-12-13 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13847809#comment-13847809 ] Eric Hanson commented on HIVE-5996: --- Thanks Xuefu for closing this one. You make some

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

2013-12-12 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13846553#comment-13846553 ] Eric Hanson commented on HIVE-5996: --- Xuefu, I'm all for new, useful functionality and

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

2013-12-12 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13846635#comment-13846635 ] Eric Hanson commented on HIVE-5996: --- Xuefu, I see you want to make changes to have Hive

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

2013-12-12 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13846705#comment-13846705 ] Xuefu Zhang commented on HIVE-5996: --- [~ehans] Thanks for sharing your thoughts and your

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

2013-12-12 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13846718#comment-13846718 ] Thejas M Nair commented on HIVE-5996: - bq. Now, to answer the same questions, I can

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

2013-12-12 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13846721#comment-13846721 ] Thejas M Nair commented on HIVE-5996: - Regarding the specific change in this jira, I am

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

2013-12-12 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13847150#comment-13847150 ] Xuefu Zhang commented on HIVE-5996: --- {quote} It would be great if you can document the

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

2013-12-11 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13845634#comment-13845634 ] Eric Hanson commented on HIVE-5996: --- -1 We should not be changing the output data types

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

2013-12-11 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13845650#comment-13845650 ] Thejas M Nair commented on HIVE-5996: - [~xuefuz] Can you please mark any jiras that

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

2013-12-11 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13845664#comment-13845664 ] Xuefu Zhang commented on HIVE-5996: --- Okay. Will do. Query for sum of a long column of a

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

2013-12-11 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13845760#comment-13845760 ] Xuefu Zhang commented on HIVE-5996: --- {quote} Having sum(bigint) return bigint is long

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

2013-12-11 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13846033#comment-13846033 ] Thejas M Nair commented on HIVE-5996: - I am curious what the datatype for sum(l) is in

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

2013-12-11 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13846067#comment-13846067 ] Xuefu Zhang commented on HIVE-5996: --- {code} mysql create table test74 as select sum(l)

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

2013-12-10 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13844551#comment-13844551 ] Hive QA commented on HIVE-5996: --- {color:red}Overall{color}: -1 at least one tests failed

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

2013-12-09 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13843972#comment-13843972 ] Xuefu Zhang commented on HIVE-5996: --- For information, the follow is the text from