pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olga Natkovich (JIRA)" <j...@apache.org>
Subject [jira] Created: (PIG-797) Limit with ORDER BY producing wrong results
Date Fri, 01 May 2009 20:13:30 GMT
Limit with ORDER BY producing wrong results
-------------------------------------------

                 Key: PIG-797
                 URL: https://issues.apache.org/jira/browse/PIG-797
             Project: Pig
          Issue Type: Bug
    Affects Versions: 0.2.0
            Reporter: Olga Natkovich


Query:

A = load 'studenttab10k' as (name, age, gpa);
B = group A by name;
C = foreach B generate group, SUM(A.gpa) as rev;
D = order C by rev;
E = limit D 10;
dump E;

Output:

(alice king,31.7)
(alice laertes,26.450000000000003)
(alice thompson,25.869999999999997)
(alice van buren,23.59)
(bob allen,19.900000000000002)
(bob ichabod,29.0)
(bob king,28.459999999999994)
(bob miller,10.28)
(bob underhill,28.139999999999997)
(bob van buren,25.990000000000002)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message