title: Accessing and Refining your SQL results in Hive and Impala author: admin type: post date: 2016-08-26T06:14:17+00:00 url: /new-features-in-the-sql-results-grid-in-hive-and-impala/ sf_thumbnail_type:
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.
You can activate the new search either by clicking on the magnifier icon on the results tab, or pressing Ctrl/Cmd + F
The table you see here has hundreds of columns
And Hue will tell you in the download has been truncated too!
As usual you can send feedback and participate on the hue-user list or @gethue!