You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Santhosh Srinivasan (JIRA)" <ji...@apache.org> on 2008/09/17 22:35:44 UTC
[jira] Commented: (PIG-430) Projections in nested filter and inside
foreach do not work
[ https://issues.apache.org/jira/browse/PIG-430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12631933#action_12631933 ]
Santhosh Srinivasan commented on PIG-430:
-----------------------------------------
Replace the double quotes with the single quotes and it should work.
{code}
A = load 'file';
B = group A by $0;
C = foreach B { C1=distinct 'const'; generate C1;};
{code}
> Projections in nested filter and inside foreach do not work
> -----------------------------------------------------------
>
> Key: PIG-430
> URL: https://issues.apache.org/jira/browse/PIG-430
> Project: Pig
> Issue Type: Bug
> Affects Versions: types_branch
> Reporter: Santhosh Srinivasan
> Assignee: Shravan Matthur Narayanamurthy
> Fix For: types_branch
>
> Attachments: 430-1.patch
>
>
> The following queries do not work:
> Nested filter:
> a = load 'studenttab10k' as (name, age, gpa);
> b = filter a by age < 20;
> c = group b by age;
> d = foreach c { cf = filter b by gpa < 3.0; cp = cf.gpa; cd = distinct cp; co = order cd by $0; generate group, flatten(co); }
> store d into 'output';
> Nested Distinct:
> a = load '/user/pig/tests/data/singlefile/studenttab10k' as (name, age, gpa);
> b = group a by name;
> c = foreach b { aa = distinct a.age; generate group, COUNT(aa); }
> store c into 'output';
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.