Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Pig ERROR 1066: Unable to open iterator for alias

Solved Go to solution

Pig ERROR 1066: Unable to open iterator for alias

Contributor

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

Accepted Solutions
Highlighted

Re: Pig ERROR 1066: Unable to open iterator for alias

Contributor

The problem was in SSSD

2 REPLIES 2

Re: Pig ERROR 1066: Unable to open iterator for alias

Contributor

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

Highlighted

Re: Pig ERROR 1066: Unable to open iterator for alias

Contributor

The problem was in SSSD

Don't have an account?
Coming from Hortonworks? Activate your account here