How to disable kerberos in hive once it has been enabled in cloudera?

@Bhavs, Welcome to our community! To help you get the best possible answer, I have tagged our Hive experts @ggangadharan @RAGHUY who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

@Bhavs Disabling Kerberos for a specific service in Hive isn’t directly supported, as Kerberos is typically enabled cluster-wide for enhanced security. If your cluster setup allows, you can configure a separate instance of HiveServer2 without Kerberos. This setup would require an additional HiveServer2 instance configured with authentication set toNONE, and it would run separately from the kerberized services.

If you use a combination of LDAP or custom authentication alongside Kerberos. If you only need to bypass Kerberos for certain users, setting up LDAP authentication with Ranger might help.

It's not recommended to disable kerberos . At the same time it's not direct way to disable kerberos. 

You can try to follow the below community post to check if that helps.

https://community.cloudera.com/t5/Support-Questions/Disabling-Kerberos/m-p/19934#M38077

https://community.cloudera.com/t5/Customer/How-to-Revert-Kerberos-Configuration-from-a-Cloudera-Managed/ta-p/73464

@Bhavs, Did the response help resolve your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.