You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Akash Mishra <ak...@gmail.com> on 2014/12/11 14:09:09 UTC
How to find Optimize query plan for given Query?
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
Re: How to find Optimize query plan for given Query?
Posted by Lefty Leverenz <le...@gmail.com>.
"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류승우 <na...@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 <ak...@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
> >
>
Re: How to find Optimize query plan for given Query?
Posted by Navis류승우 <na...@nexr.com>.
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 <ak...@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
>