Accessing and Refining your SQL results in Hive and Impala

Accessing and Refining your SQL results in Hive and Impala

Aloha Big Questions Askers!

The SQL Editor in Hue 3.11 brings a completely re-written result grid that improves the performances allowing big tables to be displayed without the browser to crash, plus some nifty tools for you.

You can now lock some rows: this will help you compare data with other rows

When you hover a row id, you get a new lock icon. If you click on it, the row automatically sticks to the top of the table.

The column list follows the result grid, can be filtered by data type and can be resized (finally!)


The headers of fields with really long content will follow your scroll position and always be visible


You can now search in the table and the results are highlighted

You can activate the new search either by clicking on the magnifier icon on the results tab, or pressing Ctrl/Cmd + F

The virtual renderer display just the cells you need at that moment

The table you see here has hundreds of columns

If the download to Excel or CSV takes too long, you will have a nice message now

And Hue will tell you in the download has been truncated too!
Screenshot 2016-08-25 19.37.26
As usual you can send feedback and participate on the hue-user list or @gethue!



  1. yoyodai 2 years ago

    hello,When I use sparksql, the task engine is using MapReduce not spark?
    my configuration :
    it is error when interface is livy
    livy server is open

    • Author
      Hue Team 2 years ago

      This will expect to have the Thrift Spark SQL server running on port 10000. Is it what you have?

  2. ahamed 2 years ago

    Is it possible to export the results from an RDBMS query into Hive tables? I guess we can export the results as CSV and then import it. But are there any other simplified option in Hue?

    • Author
      Hue Team 2 years ago

      It is currently not possible, but we are looking at integrating Sqoop to the Importer/Create table wizard to allow this.

  3. Pranav 2 years ago

    Hi Hue team,

    When I download the data from result in CSV or XLS file, not all of the records get downloaded. Is this happening because the result is limited to certain number of records by default? Or something else?

  4. xiaonianwen 3 weeks ago

    hello ,when i execute a hive query ,i can not get the log of execution,only “WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.”
    how can i configure it ?
    Thank you very much.
    sorry for my bad English.

Leave a reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.