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 Wed, 17 Jun 2009 19:02: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-3.patch

This patch include Santhosh's comment. It is obviously a problem. Thanks!

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