hadoop-pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] Commented: (PIG-797) Limit with ORDER BY producing wrong results
Date Sat, 20 Jun 2009 11:42:07 GMT

    [ https://issues.apache.org/jira/browse/PIG-797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12722178#action_12722178
] 

Hudson commented on PIG-797:
----------------------------

Integrated in Pig-trunk #480 (See [http://hudson.zones.apache.org/hudson/job/Pig-trunk/480/])
    : Limit with ORDER BY producing wrong results


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


Mime
View raw message