I have a requirement to run a job using HIVE permission without actually using HIVE keytab file. Since iam using Ranger [hive.server2.enable.doAs ] should not use correct me if iam wrong. Help how to acheive this..
hive.server2.enable.doAs to false will get you exactly that. Ultimate job gets submitted as user 'hive', but you will submit your query using your user keytab (not hive keytab).
Thanks for your update. But iam also using Ranger. I heard that making that parameter FALSE will affect other configuration. Please confirm
@suresh krish even if you are using ranger then also hive.server2.enable.doAs will be used, configure hive.server2.enable.doAs=false , but make sure you have default policy configured for hive user too.
You can achieve this by using hive.server2.enable.doAs is set to "false" which means is that Hiveserver2 will run jobs in HDFS as "hive" user. You are right, using this approach have its own drawback. One of them below:-