Setting a limit to -1 is not recommended as it could have a severe performance impact. It is better to set it to the value that may resolve your issue. Or it is suggested to change the value to default again once you are done with your job.    It will make Hue Server slow or process exited with out of memory issues, and the root cause is mostly downloading large files.   The following options currently exist for downloading files through the Impala and Hive editors: Use XLS if result set is <= 30K rows Use CSV if result set is > 30K rows Use Hue Safety Valve for CSV if result set > 1M rows (default). While this limitation can be bypassed, doing so may have a negative impact on performance. From Cloudera Manager, navigate toHue > Configuration > Service-Wide > Advanced > Hue Server Advanced Configuration Snippet (Safety Value) for hue_safety_valve_server.ini   Regards, Tarun Jangid ... View more