Configure access to managed tables from Spark

You need to configure properties in Cloudera Manager for write authorization to Hive managed tables when accessing the tables from Spark.

You add the following properties and values to hive-site.xml for HiveServer-Ranger integration:
hive.security.authorization.manager
Value: org.apache.ranger.authorization.hive.authorizer.RangerHiveAuthorizerFactory
hive.security.authorization.enabled
Value: true
  1. In Cloudera Manager, to configure Hive Metastore properties click Clusters > Hive-on-Tez > Configuration .
  2. Search for each property.
  3. Set the value given above.
  4. Save changes.