[PIG-761] ERROR 2086 on simple JOIN

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.2.0
• Fix Version/s: 0.6.0

Environment

mapreduce mode

• Hadoop Flags: Reviewed
• Assignee: Daniel Dai
• Reporter: Vadim Zaliva
• Created: 09/Apr/09 00:53
• Updated: 24/Mar/10 22:15
• Resolved: 25/Dec/09 00:20

Description

ERROR 2086: Unexpected problem during optimization. Could not find all LocalRearrange operators.org.apache.pig.impl.logicalLayer.FrontendException: ERROR 1002: Unable to store alias 109

doing pretty straightforward join in one of my pig scripts. I am able to 'dump' both relationship involved in this join. when I try to join them I am getting this error.

Here is a full log:

ERROR 2086: Unexpected problem during optimization. Could not find all
LocalRearrange operators.
org.apache.pig.impl.logicalLayer.FrontendException: ERROR 1002: Unable
to store alias 109
at org.apache.pig.PigServer.registerQuery(PigServer.java:296)
at org.apache.pig.tools.grunt.GruntParser.processPig(GruntParser.java:529)
at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:280)
at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:99)
at org.apache.pig.tools.grunt.Grunt.run(Grunt.java:75)
at org.apache.pig.Main.main(Main.java:319)
Caused by: org.apache.pig.backend.executionengine.ExecException: ERROR
2043: Unexpected error during execution.
at org.apache.pig.backend.hadoop.executionengine.HExecutionEngine.execute(HExecutionEngine.java:274)
at org.apache.pig.PigServer.executeCompiledLogicalPlan(PigServer.java:700)
at org.apache.pig.PigServer.execute(PigServer.java:691)
at org.apache.pig.PigServer.registerQuery(PigServer.java:292)
... 5 more
Caused by: org.apache.pig.impl.plan.optimizer.OptimizerException:
ERROR 2086: Unexpected problem during optimization. Could not find all
LocalRearrange operators.
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.plans.POPackageAnnotator.handlePackage(POPackageAnnotator.java:116)
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.plans.POPackageAnnotator.visitMROp(POPackageAnnotator.java:88)
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceOper.visit(MapReduceOper.java:194)
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceOper.visit(MapReduceOper.java:43)
at org.apache.pig.impl.plan.DepthFirstWalker.depthFirst(DepthFirstWalker.java:65)
at org.apache.pig.impl.plan.DepthFirstWalker.depthFirst(DepthFirstWalker.java:67)
at org.apache.pig.impl.plan.DepthFirstWalker.depthFirst(DepthFirstWalker.java:67)
at org.apache.pig.impl.plan.DepthFirstWalker.depthFirst(DepthFirstWalker.java:67)
at org.apache.pig.impl.plan.DepthFirstWalker.walk(DepthFirstWalker.java:50)
at org.apache.pig.impl.plan.PlanVisitor.visit(PlanVisitor.java:51)
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.
MapReduceLauncher.compile(MapReduceLauncher.java:198)
at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher.launchPig(MapReduceLauncher.java:80)
at org.apache.pig.backend.hadoop.executionengine.HExecutionEngine.execute(HExecutionEngine.java:261)
... 8 more
ERROR 1002: Unable to store alias 398
org.apache.pig.impl.logicalLayer.FrontendException: ERROR 1002: Unable
to store alias 398
at org.apache.pig.PigServer.registerQuery(PigServer.java:296)
at org.apache.pig.tools.grunt.GruntParser.processPig(GruntParser.java:529)
at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:280)
at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:99)
at org.apache.pig.tools.grunt.Grunt.run(Grunt.java:75)
at org.apache.pig.Main.main(Main.java:319)
Caused by: java.lang.NullPointerException
at org.apache.pig.backend.hadoop.executionengine.physicalLayer.LogToPhyTranslationVisitor.visit(LogToPhyTranslationVisitor.java:669)
at org.apache.pig.impl.logicalLayer.LOCogroup.visit(LOCogroup.java:330)
at org.apache.pig.impl.logicalLayer.LOCogroup.visit(LOCogroup.java:41)
at org.apache.pig.impl.plan.DependencyOrderWalker.walk(DependencyOrderWalker.java:68)
at org.apache.pig.impl.plan.PlanVisitor.visit(PlanVisitor.java:51)
at org.apache.pig.backend.hadoop.executionengine.HExecutionEngine.compile(HExecutionEngine.java:246)
at org.apache.pig.PigServer.compilePp(PigServer.java:771)
at org.apache.pig.PigServer.executeCompiledLogicalPlan(PigServer.java:697)
at org.apache.pig.PigServer.execute(PigServer.java:691)
at org.apache.pig.PigServer.registerQuery(PigServer.java:292)
... 5 more