https://community.cloudera.com/t5/Support-Questions/How-to-disable-kerberos-for-HiveServer2/m-p/394392#M248714 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/106900">@steinsgate</a>&nbsp;</P><P>Its definitely not recommended to disable Kerberos for Hive. However if you still want to disable Kerberos please do it at a cluster level and not at Hive level. This is not a supported / certified combination. Thats to have your cluster kerberos but Hive not kerberized. Its either you cluster is Kerberos enabled or not.&nbsp;</P> Wed, 02 Oct 2024 16:14:09 GMT ajay_riddler 2024-10-02T16:14:09Z https://community.cloudera.com/t5/Support-Questions/How-to-disable-kerberos-for-HiveServer2/m-p/394297#M248688 <P>Hello everyone,</P><P>We would like to try disabling Hive Kerberos on CDP 7.1.7.</P><P>Here are the parameters we tried disabling:</P><P><SPAN>Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml</SPAN></P><P>hive.server2.authentication.kerberos.principal&nbsp;</P><P>hive.server2.authentication.kerberos.keytab</P><P>hive.server2.authentication&nbsp;NONE</P><P>hive.security.authorization.enabled&nbsp;false</P><P>hive.server2.enable.impersonation&nbsp;false</P><P>hive.metastore.sasl.enabled&nbsp;false</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="steinsgate_0-1727776603366.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/41952iD5E3F71029094682/image-size/medium?v=v2&amp;px=400" role="button" title="steinsgate_0-1727776603366.png" alt="steinsgate_0-1727776603366.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="steinsgate_1-1727776618325.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/41953i6D6CF7E3DC0302CD/image-size/medium?v=v2&amp;px=400" role="button" title="steinsgate_1-1727776618325.png" alt="steinsgate_1-1727776618325.png" /></span></P><P>Hive Service Advanced Configuration Snippet (Safety Valve) for core-site.xml</P><P>hadoop.security.authentication&nbsp;simple</P><P>hadoop.security.authorization&nbsp;false</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="steinsgate_3-1727776672222.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/41955i2919A4970C569DF6/image-size/medium?v=v2&amp;px=400" role="button" title="steinsgate_3-1727776672222.png" alt="steinsgate_3-1727776672222.png" /></span></P><P>After turning off the following parameters and restarting HiveServer2, we noticed that HiveServer2 still seems to fail due to Kerberos authentication.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="steinsgate_5-1727777024931.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/41957iE71527DAEAD2A4AE/image-size/medium?v=v2&amp;px=400" role="button" title="steinsgate_5-1727777024931.png" alt="steinsgate_5-1727777024931.png" /></span></P><DIV class="text-base py-[18px] px-3 md:px-4 m-auto w-full md:px-5 lg:px-4 xl:px-5"><DIV class="mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]"><DIV class="group/conversation-turn relative flex w-full min-w-0 flex-col"><DIV class="flex-col gap-1 md:gap-3"><DIV class="flex max-w-full flex-col flex-grow"><DIV class="min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words [.text-message+&amp;]:mt-5"><DIV class="flex w-full flex-col gap-1 empty:hidden items-end rtl:items-start"><DIV class="relative max-w-[70%] rounded-3xl px-5 py-2.5 bg-[#f4f4f4] dark:bg-token-main-surface-secondary"><DIV class="whitespace-pre-wrap">Could you please advise on how to completely disable Kerberos for HiveServer2? Thank you.</DIV><DIV class="absolute bottom-0 right-full top-0 -mr-3.5 hidden pr-5 pt-1 [.group\/conversation-turn:hover_&amp;]:block">&nbsp;</DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV><P>&nbsp;</P> Tue, 01 Oct 2024 10:04:38 GMT https://community.cloudera.com/t5/Support-Questions/How-to-disable-kerberos-for-HiveServer2/m-p/394297#M248688 steinsgate 2024-10-01T10:04:38Z https://community.cloudera.com/t5/Support-Questions/How-to-disable-kerberos-for-HiveServer2/m-p/394392#M248714 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/106900">@steinsgate</a>&nbsp;</P><P>Its definitely not recommended to disable Kerberos for Hive. However if you still want to disable Kerberos please do it at a cluster level and not at Hive level. This is not a supported / certified combination. Thats to have your cluster kerberos but Hive not kerberized. Its either you cluster is Kerberos enabled or not.&nbsp;</P> Wed, 02 Oct 2024 16:14:09 GMT https://community.cloudera.com/t5/Support-Questions/How-to-disable-kerberos-for-HiveServer2/m-p/394392#M248714 ajay_riddler 2024-10-02T16:14:09Z