[
https://issues.apache.org/jira/browse/PIG-1507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12890892#action_12890892
]
Richard Ding commented on PIG-1507:
-----------------------------------
+1
> Full outer join fails while doing a filter on joined data
> ---------------------------------------------------------
>
> Key: PIG-1507
> URL: https://issues.apache.org/jira/browse/PIG-1507
> Project: Pig
> Issue Type: Bug
> Components: impl
> Affects Versions: 0.8.0
> Reporter: Daniel Dai
> Assignee: Daniel Dai
> Fix For: 0.8.0
>
> Attachments: PIG-1507-1.patch
>
>
> The following script produce wrong result:
> test1.dat:
> 1
> 2
> 3
> test2.dat:
> 1
> 2
> pig script:
> {code}
> a = LOAD 'test1.dat' USING PigStorage() AS (d1:int);
> b = LOAD 'test2.dat' USING PigStorage() AS (d2:int);
> c = JOIN a BY d1 FULL OUTER, b BY d2;
> d = FILTER c BY d2 IS NULL;
> STORE d INTO 'test.out' USING PigStorage();
> {code}
> expected:
> 3
> We get:
> 1
> 2
> 3
> This is because we erroneously push the filter before full outer join.
> Similar issue is addressed in
> [PIG-1289|https://issues.apache.org/jira/browse/PIG-1289], but we only fix
> left/right outer join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
