I have a table in hive and I queried it using
SELECT * FROM dbname.tablename
At end of the download, I get:
The number of resulting rows was too big to be downloaded and the resulting file has been truncated to 86207 rows.
How can I get the entire result set?
To the best of my knowledge, Hue, being a lightweight web UI, doesn't support having big data tables display fully. For Select * type of queries, you may want to consider saving the results to a file in HDFS and downloading them to view offline.
As always, if you find this post useful, don't forget to accept the answer.