[ https://issues.apache.org/jira/browse/PIG-1034?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12891877#action_12891877 ]
Thejas M Nair commented on PIG-1034: ------------------------------------ I am reviewing this patch. > Pig does not support ORDER ... BY group alias > --------------------------------------------- > > Key: PIG-1034 > URL: https://issues.apache.org/jira/browse/PIG-1034 > Project: Pig > Issue Type: Bug > Affects Versions: 0.8.0 > Reporter: David Ciemiewicz > Assignee: Jeff Zhang > Fix For: 0.8.0 > > Attachments: PIG_1034.patch > > > GROUP ... ALL and GROUP ... BY produce an alias "group". > Pig produces a syntax error if you attempt to ORDER ... BY group. > This does seem like a perfectly reasonable thing to do. > The workaround is to create an alias for group using an AS clause. But I > think this workaround should be unnecessary. > Here's sample code which elicits the syntax error: > {code} > A = load 'one.txt' using PigStorage as (one: int); > B = group A all; > C = foreach B generate > group, > COUNT(A) as count; > D = order C by group parallel 1; -- group is one of the aliases in C, why > does this throw a syntax error? > dump D; > {code} -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.