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


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.

Reply via email to