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