ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1066: Unable to open iterator for alias

Question

$ pig -z tez grunt> emp = LOAD '/emp.csv, /tmp/emp/part-m-00000' using PigStorage(',') as (id:int, name:chararray, disg:chararray, sal:long, loc:chararray); 2015-12-16 21:30:21,706 [main] INFO org.apache.hadoop.conf.Configuration.deprecation - fs.default.name is deprecated. Instead, use fs.defaultFS grunt> dump emp;

Failed!

DAG PigLatin:DefaultJobName-0_scope-8:
       ApplicationId: null                                                                                                
  TotalLaunchedTasks: -1                                                                                                  
       FileBytesRead: -1                                                                                                  
    FileBytesWritten: -1                                                                                                  
       HdfsBytesRead: 0                                                                                                   
    HdfsBytesWritten: 0

Input(s):

Output(s):

2015-12-16 21:31:00,745 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1066: Unable to open iterator for alias emp
Details at logfile: /tmp/pig-err.log

Does it work on regular MR (not TEZ)? What are the contents of the log file? Are you sure those files are in HDFS? — LiMuBei, Dec 17 '15 at 10:29
Yes, they work on MR, but not working on TEZ while DUMP relarion, I am sure they are on HDFS, — Srinivasa Goud Pabba, Dec 18 '15 at 04:25
Does that mean that the dump works on MR but not on TEZ? What is the output of a `describe emp;` instead of the dump? — LiMuBei, Dec 18 '15 at 16:05
Not sure if this answer is sufficient as you claim the code in general works, but perhaps this still helps [ERROR 1066: Unable to open iterator for alias](http://stackoverflow.com/questions/34495085/error-1066-unable-to-open-iterator-for-alias-in-pig-generic-solution) here is a [generic solution](http://stackoverflow.com/a/34495086/983722). — Dennis Jaheruddin, Dec 28 '15 at 15:31

ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1066: Unable to open iterator for alias

0 Answers0