Enabling stored procedures for Hive on Cloudera Base on premises

To create, edit, and drop procedures and functions that are written in Hive Hybrid Procedural SQL (HPL/SQL) using the Hue query editor, you must enable the hplsql option in the Hue Advanced Configuration Snippet.

Log in to Cloudera Manager as an administrator.
Go to Clusters > Hue > Configuration and add the following lines in the Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini field:
```
[notebook]
  [[interpreters]]
    [[[hive]]]
      name=Hive
      interface=hiveserver2
    [[[hplsql]]]
      name=Hplsql
      interface=hiveserver2
```
Click Save Changes.
Restart the Hue service.
Go to Clusters > Hive on Tez > Configuration and add the following property name and its value in the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml field:
Name: hive.security.authorization.sqlstd.confwhitelist.append

Value: QUERY_EXECUTOR|HPLSQL
Click Save Changes.
Restart the Hive on Tez service.