Cloudera Docs

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: 
    [notebook]
  [[interpreters]]
    [[[hive]]]
      name=Hive
      interface=hiveserver2
    [[[hplsql]]]
      name=Hplsql
      interface=hiveserver2
  4. Click APPLY.
  5. Restart the Virtual Warehouse.