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 hue-safety-valve from the Configuration files drop-down list. and select
Add the following lines in the hue-safety-valve:
[notebook] [[interpreters]] [[[hive]]] name=Hive interface=hiveserver2 [[[hplsql]]] name=Hplsql interface=hiveserver2
- Click APPLY.
- Restart the Virtual Warehouse.