How to Enable Hive's Strict Mode Configuration and Metastore Authorization Configuration after Upgrade to BDA 3.* from BDA 2.*
(Doc ID 1916565.1)
Last updated on NOVEMBER 11, 2019
Applies to:Big Data Appliance Integrated Software - Version 3.0.1 and later
In BDA V2.*/CDH 4.* releases the the CM Hive service: "Service Configuration Safety Valve for hive-site.xml" property is used to enable Hive's strict mode setting and enable Hive's metastore authorization storage checks with the following configuration update:
<description>The mode in which the hive operations are being performed. In strict mode, some risky queries are not allowed to run</description>
<description>Should the metastore do authorization checks against the underlying storage for operations like drop-partition (disallow the drop-partition if the user in question doesn't have permissions to delete the corresponding directory on the storage).</description>
After upgrading to BDA 3.* / CDH 5.* Hive's "Service Configuration Safety Valve for hive-site.xml" property is no longer present.
The goal here is to define what configuration can be used in to specify these properties in BDA 3.* / CDH 5.*.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document