Reusing alias name in nested foreach causes incorrect results
-------------------------------------------------------------
Key: PIG-2530
URL: https://issues.apache.org/jira/browse/PIG-2530
Project: Pig
Issue Type: Bug
Affects Versions: 0.9.2, 0.10
Reporter: Vivek Padmanabhan
Priority: Critical
The below script results in incorrect output for Pig 0.10 but runs fine with
Pig 0.8,
{code}
input.txt
1 4
1 3
2 3
2 4
{code}
{code}
a = load 'input.txt' as (v1:int, v2:int);
b = group a by v1;
c = foreach b { x = a; x = order x by v2 asc; generate flatten(x); }
store c into 'c1';
{code}
Output from Pig 0.10
--------------------
1 4
1 3
2 3
2 4
Looking at the explain, it seems like the sorting is entirely missed out.
The script produces correct results if I change the alias name ie;
c = foreach b { x = a; x1 = order x by v2 asc; generate flatten(x1); }
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
