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