Support Questions

Find answers, ask questions, and share your expertise

View SQL for Hive job

Explorer

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.

1 ACCEPTED SOLUTION

Contributor

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.

View solution in original post

4 REPLIES 4

Explorer

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

Contributor

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.

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

Explorer
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
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.