Downloading and exporting data from Hue

Hue enables you to download or export data from Hue to HDFS or to an external storage location from Hue Editor, Hue Dashboard, and the Hue File browser. You can limit the number of rows or bytes that are downloaded or disable the export feature altogether so that you do not run out of storage space.

Requied Role: Administrator.

For a service-wide change, go to Cloudera Manager > Clusters > Hue service > Configuration and specify the configurations in the Hue Service Advanced Configuration Snippet (Safety valve) for hue_safety_valve.ini field.

By default, Hue users can download the query results from the Hue Editor, the Hue Dashboard, and the File browser.

Limiting the number of rows to download

Specify the following in the Hue Service Advanced Configuration Snippet (Safety valve) for hue_safety_valve.ini to limit the number of rows that can be downloaded from a query before it is truncated:
[beeswax]
download_row_limit=x

x represents the number of rows that you can download.

By default, there is no download limit, and you can configure this by setting the value to -1:
[beeswax]
download_row_limit=-1

Limiting the number of bytes to download

Specify the following in the Hue Service Advanced Configuration Snippet (Safety valve) for hue_safety_valve.ini to limit the number of bytes that can be downloaded from a query before it is truncated:
[beeswax]
download_bytes_limit=x

x represents the number of bytes that you can download.

By default, there is no download limit, and you can configure this by setting the value to -1:
[beeswax]
download_bytes_limit=-1

Disabling the data download feature

Specify the following in the Hue Service Advanced Configuration Snippet (Safety valve) for hue_safety_valve.ini field to disable your users from downloading query results:
[desktop]
enable_download=false
Specify the following in the Hue Service Advanced Configuration Snippet (Safety valve) for hue_safety_valve.ini field to hide the Download button from the Hue File browser:
[filebrowser]
show_download_button=false