Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Pig ERROR 1066: Unable to open iterator for alias

avatar
Rising Star

Dear Cloudera Community, please help me to solve the problem with Pig job.

 

Some users not all have problems with script

 

events = load '/data/events/default/year=2018/month=07' using AvroStorage();
ev = limit events 100;
dump

 

The error looks like

 

2018-10-24 16:06:12,483 [main] INFO  org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - Failed!
2018-10-24 16:06:12,485 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1066: Unable to open iterator for alias ev
Details at logfile: /data/users/bigdata17/pig_1540382728474.log

 

All users are in the same group and have permissions to read on the folders.

 

HadoopVersion 5.9.3

Pig 0.12.0

 

1 ACCEPTED SOLUTION

avatar
Rising Star

The problem was in SSSD

View solution in original post

2 REPLIES 2

avatar
Rising Star

Yarn log

 

Diagnostics: Application application_1540299431797_0022 initialization failed (exitCode=255) with output: main : command provided 0
main : run as user is ххх
main : requested yarn user is ххх
User ххх not found
Failing this attempt. Failing the application

avatar
Rising Star

The problem was in SSSD