[ 
https://issues.apache.org/jira/browse/PIG-1491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12886908#action_12886908
 ] 

Scott Carey commented on PIG-1491:
----------------------------------

more readable:

{code}
DATA_G = COGROUP A by (a, b, c, d) OUTER, B by (a, b, c, d) OUTER;
DATA = FOREACH DATA_G { 
  a_items = DISTINCT A.x;
  b_items = DISTINCT B.x;
  GENERATE 
  FLATTEN(group) as (a,b,c,d),
  SUM(A.m) as m, SUM(A.n) as n,
  COUNT(a_items) as a_item_count,
  (long)(SUM(B.u) + (double)0.5) as u,
  (long)(SUM(B.v) + (double)0.5) as v,
  COUNT(b_items) as b_item_count;
}
{code}

> Failure planning nested FOREACH with DISTINCT, POLoad cannot be cast to 
> POLocalRearrange
> ----------------------------------------------------------------------------------------
>
>                 Key: PIG-1491
>                 URL: https://issues.apache.org/jira/browse/PIG-1491
>             Project: Pig
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>            Reporter: Scott Carey
>
> I have a failure that occurs during planning while using DISTINCT in a nested 
> FOREACH. 
> Caused by: java.lang.ClassCastException: 
> org.apache.pig.backend.hadoop.executionengine.physicalLayer.relationalOperators.POLoad
>  cannot be cast to 
> org.apache.pig.backend.hadoop.executionengine.physicalLayer.relationalOperators.POLocalRearrange
>         at 
> org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.SecondaryKeyOptimizer.visitMROp(SecondaryKeyOptimizer.java:352)
>         at 
> org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceOper.visit(MapReduceOper.java:218)
>         at 
> org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceOper.visit(MapReduceOper.java:40)
>         at 
> org.apache.pig.impl.plan.DepthFirstWalker.depthFirst(DepthFirstWalker.java:67)

-- 
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