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.

  1. Log in to the Data Warehouse service as an administrator.
  2. Go to Virtual Warehouse > Edit > CONFIGURATIONS > Hue and select hue-safety-valve from the Configuration files drop-down list.
  3. Add the following lines in the hue-safety-valve:
  4. Click APPLY.
  5. Restart the Virtual Warehouse.