hive query user notfound

[#1]

We have HDP 2.6.4, we have user janu, when she runs the first sql it works fine, 2 sql gives below error

we have kerberos enabled and users were created using ldap

1)select * from db.tbl

2) select col1 from db.tbl group by col1

AM Container for appattempt_1523646395030_2519_000002 exited with exitCode: -1000 For more detailed output, check the application tracking page: http://ctcl-hdpmaster3.com:8088/cluster/app/application_1523646395030_2519 Then click on links to logs of each attempt. Diagnostics: Application application_1523646395030_2519 initialization failed (exitCode=255) with output: main : command provided 0 main : run as user is janu main : requested yarn user is janu User janu not found Failing this attempt

[#2]

@vishal dutt

When you run the 1st query it's not triggering any MapReduce program. It's directly reading the data but when you define a logic it's triggering mapreduce program to perform aggregations. When it's running mapreduce program, user id need to be present on all the Resource Managers.

Hope this helps you and let me know if you need any further information.

[#3]

U mean create user on all data nodes? we have user created on 3 master nodes & edge node

[#4]

@vishal dutt

Yup, you need to create them on all the nodes. If you are using the LDAP, please bind those nodes to LDAP so that if you do id janu all the nodes you should able to see her id.

[#5]

U mean create user on all data nodes? we have user created on 3 master nodes & edge node