hadoop-pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Dai (JIRA)" <j...@apache.org>
Subject [jira] Updated: (PIG-797) Limit with ORDER BY producing wrong results
Date Mon, 15 Jun 2009 21:12:07 GMT

     [ https://issues.apache.org/jira/browse/PIG-797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Daniel Dai updated PIG-797:
---------------------------

    Attachment: PIG-797.patch

For the limited sort case, the extra limit map-reduce operator introduced in [PIG-364|http://issues.apache.org/jira/browse/PIG-364]
should use the same output key as the previous sort map-reduce operator. 

> 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
>         Attachments: 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.


Mime
View raw message