[ https://issues.apache.org/jira/browse/PIG-3807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13941045#comment-13941045 ]
David Dreyfus commented on PIG-3807: ------------------------------------ Hi Daniel, How can I locate jar files with these patches implemented? Thank you Sent from my iPhone > Pig creates wrong schema after dereferencing nested tuple fields with sorts > --------------------------------------------------------------------------- > > Key: PIG-3807 > URL: https://issues.apache.org/jira/browse/PIG-3807 > Project: Pig > Issue Type: Bug > Components: parser > Affects Versions: 0.12.0 > Reporter: David Dreyfus > Assignee: Daniel Dai > Fix For: 0.13.0 > > Attachments: PIG-3807-1.patch, test_data.txt > > > The following script fails: > d1 = load 'test_data.txt' USING PigStorage() AS (f1: int, f2: int, f3: int, > f4: int); > d2 = load 'test_data.txt' USING PigStorage() AS (f1: int, f2: int, f3: int, > f4: int); > n1 = foreach (group d1 by f1) { > -- the sorting causes the error > sorted = ORDER d1 by f2; > generate group, flatten(d1.f3) as x3; > }; > n2 = foreach (group d2 by f1) { > sorted = ORDER d2 by f2; > generate group, flatten(d2.f3) as q3; > }; > describe n1; > describe n2; > joined = join n1 by (x3), n2 by (q3); > describe joined; > final = foreach joined generate n1::x3; > dump final; > -- selected output below > n1: {group: int,x3: int} > n2: {group: int,q3: int} > joined: {n1::group: int,n1::x3: int,n2::group: int,n2::q3: int} > 2014-03-11 19:16:35 ERROR Grunt:125 - ERROR 1025: > <file , line 17, column 32> Invalid field projection. Projected field > [n1::x3] does not exist in schema: > n1::f1:int,n1::f2:int,n1::f3:int,n1::f4:int,n2::f1:int,n2::f2:int,n2::f3:int,n2::f4:int. > Details at logfile: -- This message was sent by Atlassian JIRA (v6.2#6252)