09-28-2017 07:16 AM
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>
Solved! Go to Solution.
09-28-2017 01:44 PM
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
09-28-2017 01:58 PM
Thanks! Yes I was able to set this using the CM Hive->configuration->Scope Hive (Service wide). Then restart the Hive service.