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


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;


(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.

View raw message