question Re: hive running query from different user but user name is same in Archives of Support Questions (Read Only)

hive running query from different user but user name is same

vinayk — Tue, 12 Jun 2018 19:23:24 GMT

HI Team,

I have three node Cluster. I have enabled kerberos in cluster environment. While i'm running any hive query from different users, I'm getting only hive username in history server username who is running query.

How can i enable owner name in application?

sample screenshot attached.

Regards,

Vinay

capture1.png

Re: hive running query from different user but user name is same

falbani — Sun, 18 Aug 2019 02:20:08 GMT

@Vinay K You need to enable user impersonation in hive configuration. Set hive.server2.enable.doAs = true save and restart hive server2. When doAs is set to false, queries execute as the Hive user and not the end user. Setting it to true so that queries will be run as end user instead.

In ambari you can do this change in Hive > Configs > Settings >

HTH

*** If you found this answer addressed your question, please take a moment to login and click the "accept" link on the answer.

Re: hive running query from different user but user name is same

vinayk — Wed, 13 Jun 2018 11:55:34 GMT

@Felix Albani

It's working. Thanks for quick response.

Now i'm running query from end, I'm getting below error in hiveserver2.log

Diagnostics: Application application_1528797729105_0016 initialization failed (exitCode=255) with output: main : command provided 0 main : run as user is asif main : requested yarn user is asif User asif not found

I've configured Kerberos & ranger integrated with Active Directory. I've configured one way trust MIT KDC.

asif user have own kerberos ticket. But still asif user not found.

Can you further help me?

Thanks.

Re: hive running query from different user but user name is same

bhanu_pamu — Wed, 13 Jun 2018 13:40:32 GMT

@Vinay K

What is the OS you are running on.
Do you have OS user with the same name ?
Do you see hdfs directory for that user in /user/asif
Are you querying on internal or external hive table ?

Re: hive running query from different user but user name is same

vinayk — Wed, 13 Jun 2018 13:49:13 GMT

@Bhanu Pamu

I'm using CentOS 7.3
No i don't any user on OS with same name. I'm using AD users.
Yes, I'd created asif user directory in /user.
I'm running query on internal hive table.