hadoop-pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Ciemiewicz (JIRA)" <j...@apache.org>
Subject [jira] Created: (PIG-1034) Pig does not support ORDER ... BY group alias
Date Wed, 21 Oct 2009 16:55:59 GMT
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.


Mime
View raw message