Enabling stored procedures for Hive in Cloudera Data Warehouse
To create, edit, and drop procedures and functions that are written in Hive Hybrid
Procedural SQL (HPL/SQL) using the Hue query editor in CDW, you must enable the hplsql
option in the hue-safety-valve field.
Log in to the Data Warehouse service as an administrator.
Go to Virtual Warehouse > Edit > CONFIGURATIONS > Hue and select hue-safety-valve from the
Configuration files drop-down list.