Databases
StackOverflow2013
Postsdbo
POPig ERROR 1066: Unable to open iterator for alias returned from UDF
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPig ERROR 1066: Unable to open iterator for alias returned from UDF
    primarykey
    data
    text
    <p>I am trying to load up my own UDF in pig. I have made it into a jar using eclipse's export function. I am getting this 1066 error when running my pig script. I am not sure <code>B = ..</code> as I can dump A, but I can not dump B.</p> <h2>Script</h2> <pre><code>REGISTER myudfs.jar; DEFINE HOUR myudfs.HOUR; A = load 'access_log_Jul95' using PigStorage(' ') as (ip:chararray, dash1:chararray, dash2:chararray, date:chararray, getRequset:chararray, status:int, port:int); B = FOREACH A GENERATE HOUR(ip); DUMP B; </code></pre> <h2>Function</h2> <pre><code>package myudfs; import java.io.IOException; import org.apache.pig.EvalFunc; import org.apache.pig.data.Tuple; import org.apache.pig.impl.util.WrappedIOException; public class HOUR extends EvalFunc&lt;String&gt; { @SuppressWarnings("deprecation") public String exec(Tuple input) throws IOException { if (input == null || input.size() == 0) return null; try{ String str = (String)input.get(0); return str.toUpperCase(); }catch(Exception e){ throw WrappedIOException.wrap("Caught exception processing input row ", e); } } } </code></pre> <h2>Running command</h2> <p><code>pig -x mapreduce 2.pig</code></p> <h2>Data Format</h2> <pre><code>199.72.81.55 - - [01/Jul/1995:00:00:01 -0400] "GET /history/apollo/ HTTP/1.0" 200 6245 | | | | | ip date getRequest status port </code></pre> <h2>Pig Stack Trace</h2> <pre><code>ERROR 1066: Unable to open iterator for alias B org.apache.pig.impl.logicalLayer.FrontendException: ERROR 1066: Unable to open iterator for alias B at org.apache.pig.PigServer.openIterator(PigServer.java:836) at org.apache.pig.tools.grunt.GruntParser.processDump(GruntParser.java:696) at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:320) at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:194) at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:170) at org.apache.pig.tools.grunt.Grunt.exec(Grunt.java:84) at org.apache.pig.Main.run(Main.java:604) at org.apache.pig.Main.main(Main.java:157) 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:601) at org.apache.hadoop.util.RunJar.main(RunJar.java:208) Caused by: java.io.IOException: Job terminated with anomalous status FAILED at org.apache.pig.PigServer.openIterator(PigServer.java:828) ... 12 more </code></pre> <p>I am extremely unfamiliar with pig, and any and all pointers would be greatly appreciated. I know this is a lot of information to look at, but I have had no luck in mutating any data in a UDF, and I am just not sure where I went wrong.</p> <p>Thanks</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USc.gutierrez
    1. USnook
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POPig ERROR 1066: Unable to open iterator for alias returned from UDF
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COThe error message you posted isn't helpful, would need to see the rest of the stack trace. Have you tried running the script through eclipse and debugging the udf? If you project a alias containing just ip and dump it what do you get?
      singulars
      1. POPig ERROR 1066: Unable to open iterator for alias returned from UDF
      1. USDMulligan
    2. CO@publ1c_stat1c Do you see any exceptions in corresponding Hadoop job's task logs? If so, could you post it?
      singulars
      1. POPig ERROR 1066: Unable to open iterator for alias returned from UDF
      1. USLorand Bendig
    3. CO@LorandBendig I get the same error when running a local job, so I think it has to do with the pig script or the udf, rather than any hadoop task. I will post the stack trace later today though, as it might help.
      singulars
      1. POPig ERROR 1066: Unable to open iterator for alias returned from UDF
      1. USnook
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload