ERROR 1066: Unable to open iterator for alias in Pig, Generic solution

by

The message “ERROR 1066: Unable to open iterator for alias myAlias” suggests that there is something going wrong in the line where you use myAlias.

However, usually you will see this error if something went wrong BEFORE you are trying to use this alias. So the first thing to do is look up further along the error message, and see whether this is truely the first error that is thrown.

Here is what I found to be an efficient way to deal with this error when I did not easily spot an earlier error:

  1. Run the code untill just before you first define the the alias.
  2. Look carefully, whether you see any mention of ERROR (often it is in the last lines, but sometimes this can happen earlier)
  3. By now you probably have an error, if so: deal with it and go to 1.
  4. It is possible that you don’t have an error before encountering the alias, in this case evaluate the line where the alias occurs.
  5. If the error occurs: Deal with it and go to 4; If no error occurs run the code untill just before you use the alias for the second time, and go to 3.

Notes:

  • To easily run PIG code line by line: Open pig on the command line (Simply type pigor pig -useHCatalog for example)
  • If you get confused, make sure you only define the alias once. (I believe this is good practice in general)

More Related Contents:

  1. What is a debugger and how can it help me diagnose problems?
  2. Accessing console and devtools of extension’s background.js
  3. In Visual Studio C++, what are the memory allocation representations?
  4. What is private bytes, virtual bytes, working set?
  5. How do you debug classic ASP?
  6. What’s the toughest bug you ever found and fixed? [closed]
  7. How do I see the expanded macro code that’s causing my compile error?
  8. Attach IntelliJ IDEA debugger to a running Java process
  9. How do I debug an MPI program?
  10. How to debug web sites on mobile devices?
  11. What is the difference between Step Into and Step Over in a debugger
  12. How to see which plugins are making Vim slow?
  13. Meteor: Debug on server side
  14. How is Linux kernel live debugging done and what tools are used?
  15. How do I skip external code when debugging in VS Code
  16. How to debug htaccess rewrite script
  17. Debugging in Clojure? [closed]
  18. What flags do you set for your GFORTRAN debugger/compiler to catch faulty code?
  19. How to get R script line numbers at error?
  20. How to go to the previous line in GDB?
  21. How to inspect the return value of a function in GDB?
  22. Visual Studio 2015 Debugging: Can’t expand local variables?
  23. How to debug Greasemonkey script with the Firebug extension?
  24. How to debug Haskell code?
  25. Visual Studio Code breakpoint appearing in wrong place
  26. How to debug Ansible issues?
  27. Functions debugging in VS Code
  28. Debugging SSIS Script task – Breakpoint is enabled but it does not hit
  29. Watch a variable (memory address) change in Linux kernel, and print stack trace when it changes?
  30. Why :sprint always prints a “_”?

Leave a Comment