[jira] [Commented] (ATLAS-549) FOREACH throwing error

["vivek singh (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ATLAS-549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179317#comment-15179317 ] 

vivek singh commented on ATLAS-549:
-----------------------------------

Hi.. I am using Pig version 0.12.0-cdh5.4.4 on cloudera version- 2.6.0-cdh5.4.4. I am getting a strange issue using FOREACH. Below is what I am trying-
a= LOAD 'GCS_AGENT/agent_downtime_test.txt' using PigStorage(',') as (agent_key:chararray, status:chararray, time:chararray);
b= FOREACH a GENERATE (chararray) $0 AS agent_key;
dump b;
It is throwing the below error-
Pig Stack Trace
---------------
ERROR 6017: Job failed!

org.apache.pig.impl.logicalLayer.FrontendException: ERROR 1066: Unable to open iterator for alias b
	at org.apache.pig.PigServer.openIterator(PigServer.java:892)
	at org.apache.pig.tools.grunt.GruntParser.processDump(GruntParser.java:774)
	at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:372)
	at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:198)
	at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:173)
	at org.apache.pig.tools.grunt.Grunt.exec(Grunt.java:84)
	at org.apache.pig.Main.run(Main.java:607)
	at org.apache.pig.Main.main(Main.java:156)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
	at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: org.apache.pig.PigException: ERROR 1002: Unable to store alias b
	at org.apache.pig.PigServer.storeEx(PigServer.java:994)
	at org.apache.pig.PigServer.store(PigServer.java:954)
	at org.apache.pig.PigServer.openIterator(PigServer.java:867)
	... 13 more
Caused by: org.apache.pig.backend.executionengine.ExecException: ERROR 6017: Job failed!
	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher.checkStopOnFailure(MapReduceLauncher.java:519)
	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher.launchPig(MapReduceLauncher.java:344)
	at org.apache.pig.PigServer.launchPlan(PigServer.java:1334)
	at org.apache.pig.PigServer.executeCompiledLogicalPlan(PigServer.java:1319)
	at org.apache.pig.PigServer.storeEx(PigServer.java:990)
	... 15 more
================================================================================

If I remove FOREACH, all the lines would work. Can you please help?

> FOREACH throwing error
> ----------------------
>
>                 Key: ATLAS-549
>                 URL: https://issues.apache.org/jira/browse/ATLAS-549
>             Project: Atlas
>          Issue Type: Bug
>            Reporter: vivek singh
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)