[ https://issues.apache.org/jira/browse/PIG-797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Dai updated PIG-797: --------------------------- Resolution: Fixed Fix Version/s: 0.4.0 Status: Resolved (was: Patch Available) Patch submitted > 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 > Assignee: Daniel Dai > Fix For: 0.4.0 > > Attachments: PIG-797-2.patch, PIG-797-3.patch, PIG-797.patch > > > 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.