Hue configurations in Cloudera Data Warehouse

You can customize the settings for Hue at a Vitrual Warehouse level by specifying the configurations in the hue-safety-valve field in the Cloudera Data Warehouse (CDW) UI.

The following table lists the safety valve parameters supported by Hue in Cloudera Data Warehouse:


Parameter	Description
`[notebook] [[interpreters]] [[[hive]]] name=Hive interface=hiveserver2 [[[hplsql]]] name=Hplsql interface=hiveserver2`	Used to activate and enable switching between Hive and HPL/SQL interpreters for your queries. note Hue enables you to switch between Hive and HPL/SQL interpreters. By default, the Hive interpreter is enabled when you create a Hive Virtual Warehouse. To enable the HPL/SQL interpreter, you must update the configuration in the hue-safety-valve field in your Hive Virtual Warehouse. However, updating hue-safety-valve overrides the default configuration. Therefore, to use both Hive and HPL/SQL interpreters, you must enable both by updating the configuration in the hue-safety-valve field.
`[[desktop]] app_blacklist`	Used to add or remove applications, such as the File Browser, Impala, Hive, Oozie, and so on from the blocked list of applications.
`[desktop] [[session]] ttl=[*NUMBER-OF-SECONDS*]`	Used to configure the duration of a user session. The `ttl` property determines the length of time that the cookie with the user's session ID lives before expiring. After the `ttl` setting is reached, the user's session expires whether it is active or not. The default setting for `ttl` is 1,209,600 seconds, which equals two weeks.
`[jobbrowser] [[query_store]] server_url=[*QUERY-PROCESSOR-URL*]`	Used to display the Queries tab for Hive and Impala on the Job Browser page. This configuration is enabled by default and is not exposed in the Hue safety valve. However, to hide the Queries tab, you can override the configuration by adding the following lines in Virtual Warehosue > > Edit > CONFIGURATIONS > Hue > hue-safety-valve: `[jobbrowser] [[query_store]] is_enabled=false` To enable the Queries tab, set `is_enabled` to `true`.