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] Commented: (PIG-1171) Top-N queries produce incorrect results when followed by a cross statement
Date Tue, 05 Jan 2010 19:19:54 GMT

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

Olga Natkovich commented on PIG-1171:
-------------------------------------

+1; patch looks good. Will be committing it to the trunk shortly

> Top-N queries produce incorrect results when followed by a cross statement
> --------------------------------------------------------------------------
>
>                 Key: PIG-1171
>                 URL: https://issues.apache.org/jira/browse/PIG-1171
>             Project: Pig
>          Issue Type: Bug
>    Affects Versions: 0.6.0
>            Reporter: Richard Ding
>            Assignee: Richard Ding
>             Fix For: 0.7.0
>
>         Attachments: PIG-1171.patch
>
>
> ??I am not sure if this is a bug, or something more subtle, but here is the problem that
I am having.??
> ??When I LOAD a dataset, change it with an ORDER, LIMIT it, then CROSS it with itself,
the results are not correct. I expect to see the cross of the limited, ordered dataset, but
instead I see the cross of the limited dataset. Effectively, its like the LIMIT is being excluded.??
> ??Example code follows:??
> {code}
> A = load 'foo' as (f1:int, f2:int, f3:int); B = load 'foo' as (f1:int, f2:int, f3:int);
> a = ORDER A BY f1 DESC;
> b = ORDER B BY f1 DESC;
> aa = LIMIT a 1;
> bb = LIMIT b 1;
> C = CROSS aa, bb;
> DUMP C;
> {code}

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