"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 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 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, > > > > Akash Mishra. > > > > > > "Its not our abilities that make us, but our decisions."--Albus > Dumbledore > > >