question Re: Pig ERROR 1066: Unable to open iterator for alias in Archives of Support Questions (Read Only)

Pig ERROR 1066: Unable to open iterator for alias

Paulina — Fri, 16 Sep 2022 13:49:45 GMT

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

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

Paulina — Wed, 24 Oct 2018 12:51:50 GMT

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

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

Paulina — Mon, 29 Oct 2018 06:30:09 GMT

The problem was in SSSD