Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Limit Query Result Rows from a Hive Table on Hue

Limit Query Result Rows from a Hive Table on Hue

New Contributor

Hi,

 

how could I limit the rows returned from a query on a Hive table using Hue 4.1.0 without using the LIMIT syntax or the parameters %_partitions_limit.

2 REPLIES 2

Re: Limit Query Result Rows from a Hive Table on Hue

Guru
Hue always returns partial result and load more data when you scroll down, is it not working for you?
Highlighted

Re: Limit Query Result Rows from a Hive Table on Hue

You could also look at the 'download_row_limit', e.g.
https://github.com/cloudera/hue/blob/master/desktop/conf.dist/hue.ini#L1087