Skip to main content
felix_
Bronze III
Jul 6, 2023 1:46 AM UTC
Solved

How to collect queries submitted by other users' keytab in DAS on CDP7.1.7

Our CDP version is 7.1.7 and enabled kerberos, after we set up DAS service on it, we found that: queries only submitted by hive.keytab can be collected to DAS, queries submitted by other users' keytab such like hdfs.keytab/generic account keytab cannot be collected.

So, does DAS only support to collect queries submitted by hive.keytab?
If not, how can I config this?

aakulov
aakulovAnswer
Platinum ⭐️
Jul 7, 2023 5:20 PM UTC

Hi @felix_ ,

 

First, you may want to check out the troubleshooting tips for DAS. In particular, there is a reference to adding a user that wants to see all queries to the admin list under DAS configuration in Cloudera Manager. 

 

Second, do you have Hive impersonation enabled or disabled on this cluster? If you are using Ranger for authorization, then impersonation should be turned off. 

 

Finally, I would advice your users to begin switching to Hue as the query and analysis UI. That is where all future engineering effort from Cloudera will go. 

 

Hope this points you in the right direction. 

- Alex

3 replies

DianaTorres
Community Manager
Community Manager
Jul 6, 2023 2:50 AM UTC

@felix_ Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our CDP expert @aakulov  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Translate
Regards, Diana Torres, Senior Community Moderator
aakulov
Platinum ⭐️
aakulovAnswer
Platinum ⭐️
Jul 7, 2023 5:20 PM UTC

Hi @felix_ ,

 

First, you may want to check out the troubleshooting tips for DAS. In particular, there is a reference to adding a user that wants to see all queries to the admin list under DAS configuration in Cloudera Manager. 

 

Second, do you have Hive impersonation enabled or disabled on this cluster? If you are using Ranger for authorization, then impersonation should be turned off. 

 

Finally, I would advice your users to begin switching to Hue as the query and analysis UI. That is where all future engineering effort from Cloudera will go. 

 

Hope this points you in the right direction. 

- Alex

Translate
Ganesha
Silver ⭐️⭐️
Jul 9, 2023 1:36 PM UTC

I find it very interesting and useful! Thank you and peace to all!

Translate