You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Jeff Zhang (JIRA)" <ji...@apache.org> on 2010/06/21 08:45:23 UTC

[jira] Assigned: (PIG-1034) Pig does not support ORDER ... BY group alias

     [ https://issues.apache.org/jira/browse/PIG-1034?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Zhang reassigned PIG-1034:
-------------------------------

    Assignee: Jeff Zhang

> 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
>            Reporter: David Ciemiewicz
>            Assignee: Jeff Zhang
>
> 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.