Hue download limit in excel

[Ravi]

Is there any download limit in Hue to excel using Hive.  We tried to download the data from Hue search dashboard grid and it downloads only 1000 rows.   What is the max limit on downloading from Hue Hive?

[saranvisa Champion]

@Ravi

It is not possible as of now, please refer these two links

https://community.cloudera.com/t5/Web-UI-Hue-Beeswax/Hue-Dashboard-Download-option/m-p/52254#M2144

https://issues.cloudera.org/browse/HUE-2142

[saranvisa Champion]

I meant not possible to get more than 1000 rows!!

[Ravi]

I understand that it is not possible to get more than 1000 rows in Hue Search dashboard, my question is what is the download limit when we download data from Hive Query Editor in Hue?

[Romainr]

It is currently 100 000 by default:
https://github.com/cloudera/hue/blob/master/desktop/conf.dist/hue.ini#L961

[Abu]

can we increase the export limit of the hue from 100 000  to 1600 000

[HalenYuri]

@Abu I think you can downaload what the Hue can show

so ... if your "download_row_limit" attribute = 100000 on hue.ini the result of your query will be truncated to 100000 and you can download this number of lines.

You can change the attibute on hue.ini or using the Configuration Snippet on Cloudera Manager.