Thanks a lot @Felix Albani...you solved my issue. ... View more

Cluster is not kerberized in my case. ... View more

@Dinesh Chitlangia Could you please paste all the properties of jdbc interpreter? In my case, when I see the property impersonation of logged in user is not working and hive user is being used for executing queries. Here is the snippet of my jdbc interpreter properties. zeppelinhiveissue.jpg ... View more

@Felix Albani I could see below lines from Zeppelin documentation. In the Zeppelin UI, navigate to the %jdbc section of the Interpreter page. Click edit, then add a hive.proxy.user.property property and set its value to hive.server2.proxy.user . Click Save, then click restart to restart the JDBC interpreter. https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.4/bk_zeppelin-component-guide/content/config-hive-access.html I believe above should be sufficient enough. As of now because of some issues we did disable plugin for Ranger and need to test it after 1-2 days once after ranger plugin is enabled. I could not see any job being executed with Zeppelin user login ID even after adding above property. ... View more

@Felix Albani...Yes your help is valuable and it worked but with one final question. Do I need to modify credentials for each and every user? How to make it generic for all users at one go? I am forced to modify credentials for testuser2. zeppelinissue.jpg ... View more

@Felix Albani many many thanks for your continuous support. I will keep you posted, once after Ranger issue is resolved. Thanks again. ... View more

Also, hive.server2.enable.doAs is set to true. ... View more

I could see below line: If Kerberos is not enabled on the cluster, no additional configuration steps are required. Hence, I believe default configuration should work properly but it is in conflict with hive user in jdbc connector. ... View more

Sorry for asking you this without checking the link you provided ( I am doing it now 😞 In my case, Kerberos is not enabled. How to change the user name from hive to the user name of the logged in user? You are correct, hive user has got full permissions and hence policy is not applied. ... View more

@Felix, I believe jdbc interpreter configuration has to be changed and I am using default settings. Here are the jdbc interpreter properties. jdbc1.jpgjdbc2.jpg I did disable plugin again and I will post the errors when I enable again. Please let me know if changes are to be made to jdbc interpreter? ... View more