Viewing Impala query history

The Impala Queries tab on the Job Browser page in Hue displays all the queries that were run from various query interfaces, such as Impala-shell, Impyla, Hue, and other JDBC BI clients and tools.

Only Query Processor Administrators can view historical queries of all users to access history of queries run in that Impala Virtual Warehouse from the Hue Job Browser. Non-admin users can only view only their own queries.

Log in to the Hue web interface.
Click Jobs from the left assist panel.
The Job Browser page is displayed.
Click Queries.
The Impala queries that were run for the past seven days are displayed. You can select the time period for which you want to view the historical data.

You can also search using the query ID, sort queries by various parameters such as duration, peak memory, and so on, and filter queries by their status.