question Re: Where to set sentry.hive.testing.mode property? in Archives of Support Questions (Read Only)

Where to set sentry.hive.testing.mode property?

ebeb — Fri, 16 Sep 2022 12:18:44 GMT

In the Cloudera 5.12.x manual it says to set the below property. Someone advised to change using Cloudera Manager. I am unable to find sentry.hive.testing.mode in CM under Hive->configuration. Also all files are generated in locations like /var/run/cloudera-scm-agent/process/467-hive-HIVESERVER2/sentry-site.xml so this file is in multiple processes and not a single location. Where do I change this property? And why does Cloudera make their docs so confusing??

If you want to override the Kerberos prerequisite for the Hive metastore, set the sentry.hive.testing.mode property to true to allow Sentry to work with weaker authentication mechanisms. Add the following property to the HiveServer2 and Hive metastore's sentry-site.xml:

<property>
  <name>sentry.hive.testing.mode</name>
  <value>true</value>
</property>

Re: Where to set sentry.hive.testing.mode property?

saranvisa — Thu, 28 Sep 2017 20:44:43 GMT

@ebeb

If you don't find the configuration by default you can use "Advanced Configuration Snippet" as follows

Also the document says "Add the following property to the HiveServer2 and Hive metastore's sentry-site.xml". So you can set your property in below locations and make sure to restart the services

1. CM -> Hive -> Configuration -> Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml

2. CM -> Sentry -> Configuration -> Sentry Service Advanced Configuration Snippet (Safety Valve) for sentry-site.xml

Re: Where to set sentry.hive.testing.mode property?

ebeb — Thu, 28 Sep 2017 20:58:47 GMT

Thanks! Yes I was able to set this using the CM Hive->configuration->Scope Hive (Service wide). Then restart the Hive service.

Hive Service Advanced Configuration Snippet (Safety Valve) for sentry-site.xml

Hive (Service-Wide)

Name: sentry.hive.testing.mode

Value: true

Description

Final