read physical plan for sql query

[Divya Gehlot <di...@gmail.com>]

Hi ,

Is there any KB which helps a beginner to read or what to look in  physical
plan of the query ?

Thanks,
Divya

Re: read physical plan for sql query

[Paul Rogers <pr...@mapr.com>]

Drill offers not just one, not just two, but three different representations of the query plan.

The first two can be had from the EXPLAIN PLAN statement. This is the textual form of the plan (shown in the query profile) and a near-complete JSON form.

There is also a third form, with memory allocations filled in, but split into fragments, that can be found in the drillbit.log file. This form of the plan shows what actually executes in each minor fragment.

- Paul

> On Nov 10, 2017, at 6:48 AM, Muhammad Gelbana <m....@gmail.com> wrote:
> 
> Have a look at this page
> <https://drill.apache.org/docs/performance-tuning-introduction/>. However,
> Drill currently shows helpful data on the query plan page. I'm referring to
> a version that comes after 1.9, I think it was 1.11.
> 
> Thanks,
> Gelbana
> 
> On Fri, Nov 10, 2017 at 11:10 AM, Divya Gehlot <di...@gmail.com>
> wrote:
> 
>> Hi ,
>> 
>> Is there any KB which helps a beginner to read or what to look in  physical
>> plan of the query ?
>> 
>> Thanks,
>> Divya
>> 

Re: read physical plan for sql query

[Muhammad Gelbana <m....@gmail.com>]

Have a look at this page
<https://drill.apache.org/docs/performance-tuning-introduction/>. However,
Drill currently shows helpful data on the query plan page. I'm referring to
a version that comes after 1.9, I think it was 1.11.

Thanks,
Gelbana

On Fri, Nov 10, 2017 at 11:10 AM, Divya Gehlot <di...@gmail.com>
wrote:

> Hi ,
>
> Is there any KB which helps a beginner to read or what to look in  physical
> plan of the query ?
>
> Thanks,
> Divya
>