question Hive Explain plan without executing the Query. in Archives of Support Questions (Read Only)

Hive Explain plan without executing the Query.

sivasankar_chan — Mon, 23 Jul 2018 14:39:43 GMT

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?

Re: Hive Explain plan without executing the Query.

sweeks — Mon, 23 Jul 2018 20:31:50 GMT

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.

sivasankar_chan — Tue, 24 Jul 2018 21:04:36 GMT

Thank You Shawn for the Response. I got it.