Hive Explain plan without executing the Query.

[#1]

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?

[#2 · Accepted solution]

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.

[#3]

Thank You Shawn for the Response. I got it.