Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive Explain plan without executing the Query.

Solved Go to solution
Highlighted

Hive Explain plan without executing the Query.

New Contributor

Hi, I am new to hive. Is there any way to get the execution plan without executing the query? like oracle set Autotrace trace only option. Also can we see the result of set Hive.tez.exec.print.summary result without executing the query?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Hive Explain plan without executing the Query.

Rising Star

You can get the explain plan by just adding the keyword EXPLAIN before the sql statement and executing it. Some SQL Tools will automatically trim part of the command so make sure you highlight EXPLAIN and the entire Query. That will just generate the plan and doesn't run the query. The TEZ Summary is a summary of actual work performed so there's no way to get it without running the query.

2 REPLIES 2

Re: Hive Explain plan without executing the Query.

Rising Star

You can get the explain plan by just adding the keyword EXPLAIN before the sql statement and executing it. Some SQL Tools will automatically trim part of the command so make sure you highlight EXPLAIN and the entire Query. That will just generate the plan and doesn't run the query. The TEZ Summary is a summary of actual work performed so there's no way to get it without running the query.

Re: Hive Explain plan without executing the Query.

New Contributor

Thank You Shawn for the Response. I got it.

Don't have an account?
Coming from Hortonworks? Activate your account here