Cloudera Docs

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. 
[[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.

 
[aws]
[[aws_accounts]]
[[[default]]]
access_key_id=[***AWS-ACCESS-KEY***]
secret_access_key=[***SECRET-ACCESS-KEY***]
region=[***AWS-REGION***]
 (Non-RAZ) Used to enable the S3 File Browser for Hue in Cloudera Data Warehouse to access an S3 bucket from Hue. 
[azure]
  [[azure_accounts]]
    [[[default]]]
      client_id=[***AZURE-ACCOUNT-CLIENT-ID***]
      client_secret=[***AZURE-ACCOUNT-CLIENT-SECRET***]
      tenant_id=[***AZURE-ACCOUNT-TENANT-ID***]

    [[abfs_clusters]]
      [[[default]]]   
		fs_defaultfs=abfs://[***CONTAINER-NAME***]@[***AZURE-STORAGE-ACCOUNT-NAME***]>.dfs.core.windows.net
              webhdfs_url=https://[***AZURE-STORAGE-ACCOUNT-NAME***].dfs.core.windows.net/
 (Non-RAZ) Used to enable the ABFS File Browser for Hue in Cloudera Data Warehouse to access ADLS Gen2 containers. 
[filebrowser]
remote_storage_home=s3a://[***S3-BUCKET-NAME***]
 (Optional) Used to set a specific home directory path for your S3 bucket.