question Re: View SQL for Hive job in Archives of Support Questions (Read Only)

View SQL for Hive job

Rekonn — Tue, 21 Apr 2026 13:48:40 GMT

In HUE's Job Browser, I can see jobs, which for us is a bunch of different hive queries submitted by several users. How can I view the SQL for a given job_id? When I see a query that's been running for a long time, I want to know what it is.

Re: View SQL for Hive job

Rekonn — Tue, 01 Nov 2016 14:49:59 GMT

If there is no way to do this, having confirmation of that would also be helpful.

Re: View SQL for Hive job

yshi — Fri, 04 Nov 2016 00:04:23 GMT

Please try click on the job, then open its "metadata" tab. In this tab, search for property "query.string". Its value should contain the full SQL.

Re: View SQL for Hive job

Romainr — Fri, 04 Nov 2016 00:39:42 GMT

Yes, or you need to look at the Query history in the Hive Editor

Re: View SQL for Hive job

gimp077 — Wed, 15 Feb 2017 14:54:46 GMT

I am not sure what you mean when you say metadata tab as I see no tab named metadata after clicking on the job. Thanks

Re: View SQL for Hive job

clumZZey — Tue, 07 Feb 2023 12:47:23 GMT

Indeed. There is no metadata tab. It is really annoying that it is nearly impossible to find your own queries in this. Also the filtering options are not great.