Support Questions

Find answers, ask questions, and share your expertise

Truncated results in hue

Expert Contributor

I have a table in hive and I queried it using

SELECT * FROM dbname.tablename

At end of the download, I get:

Your downloaded results have been truncated

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?



@Simran Kaur

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.