Reply
Highlighted
New Contributor
Posts: 2
Registered: ‎03-09-2017
Accepted Solution

HUE parameter change from Cloudera Manager:

Hi, HUE allows you to download the rows of a table into excel files, but by default the maximum number of rows that can be downloaded are 100,000 rows. The parameter that allows you to change the number of rows to download in excel from HUE is download_row_limit. How do you change this configuration parameter from the Cloudera manager? Best regards, Mirco
Explorer
Posts: 19
Registered: ‎11-04-2016

Re: HUE parameter change from Cloudera Manager:

Hi,

 

You can change your hue.ini in Cloudera Manager:

 

(take a look at beeswax section: https://github.com/cloudera/hue/blob/master/desktop/conf.dist/hue.ini)

 

[beeswax]

# A limit to the number of rows that can be downloaded from a query before it is truncated.
# A value of -1 means there will be no limit.
## download_row_limit=100000

 

Just navigate to your Hue service -> Configuration -> search for "hue_safety_valve.ini"

 

As you can see the rest is pretty easy.

Screenshot 2017-09-11 20.44.11.png

 

 

 

PS: I was always wondering where this 100K is coming from, so thanks for pointing it out :)

 

Cheers!

 

New Contributor
Posts: 2
Registered: ‎03-09-2017

Re: HUE parameter change from Cloudera Manager:

Thanks so much for your help, I've been able to solve the issue.


download_row_limit.PNG
Announcements