Re: How to find Optimize query plan for given Query?

2014-12-15 Thread Navis류승우
You can see the optimized logical operator tree by explain logical your query. And partial operator tree in stages are all optimized one. Thanks, Navis 2014-12-11 22:09 GMT+09:00 Akash Mishra akash.mishr...@gmail.com: Hi All, I am trying to understand the details of how query is optimize in

Re: How to find Optimize query plan for given Query?

2014-12-15 Thread Lefty Leverenz
Explain logical was added in Hive 0.12 (HIVE-4812 https://issues.apache.org/jira/browse/HIVE-4812). -- Lefty On Mon, Dec 15, 2014 at 6:16 PM, Navis류승우 navis@nexr.com wrote: You can see the optimized logical operator tree by explain logical your query. And partial operator tree in stages

How to find Optimize query plan for given Query?

2014-12-11 Thread Akash Mishra
Hi All, I am trying to understand the details of how query is optimize in the system? Is there anything other than EXPLAIN system. As per my understanding Abstract Syntax tree is not optimize. Is the plan in stage is the optimize physical plan ? -- With Sincere Regards, Your's Sincerely,