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.