[jira] Updated: (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
]
Thejas M Nair updated PIG-1034:
---
Status: Resolved (was: Patch Available)
Resolution: Fixed
I have committed the patch. Jeff, thanks for the contribution.
Also, marking the jira as fixed.
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.
[jira] Updated: (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 updated PIG-1034:
Status: Patch Available (was: Open)
Affects Version/s: 0.8.0
Fix Version/s: 0.8.0
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.
[jira] Updated: (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 updated PIG-1034:
Attachment: PIG_1034.patch
Attach the 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.
