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.

hive query user notfound

hive query user notfound

New Contributor

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

4 REPLIES 4

Re: hive query user notfound

@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.

Highlighted

Re: hive query user notfound

New Contributor

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

Re: hive query user notfound

@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.

Re: hive query user notfound

New Contributor

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