phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Komal Thombare <komal.thomb...@tcs.com>
Subject Re: Understand explain plan
Date Tue, 25 Nov 2014 06:30:00 GMT
Hi James,

Thank you for your reply.

I have filed a jira for this.

PHOENIX-1481 
The explanation for the explain plan for a query is not documented.
Thanks and Regards,
Komal Ravindra Thombare

-----James Taylor <jamestaylor@apache.org> wrote: -----
To: user <user@phoenix.apache.org>
From: James Taylor <jamestaylor@apache.org>
Date: 11/25/2014 08:01AM
Subject: Re: Understand explain plan

Hi Komal,
The CLIENT keyword in an explain plan means that action will be run on
the client side while SERVER means it'll run on the HBase region
server. We have not documented the meaning of an explain plan, though.
Would you mind filing a JIRA for this?
Thanks,
James

On Wed, Nov 12, 2014 at 10:21 PM, Komal Thombare <komal.thombare@tcs.com> wrote:
> Hi,
>
> I am trying to get the explain plan for below query.
>
> explain select i.itemname,i.price,sum(o.quantity) from items as i join
> orders as o on i.itemid=o.itemid group by i.itemname,i.price;
>
> I get output as below
>
> +------------+
> |    PLAN    |
> +------------+
> | CLIENT PARALLEL 1-WAY FULL SCAN OVER ITEMS |
> |     SERVER AGGREGATE INTO DISTINCT ROWS BY [I.ITEMNAME, I.PRICE] |
> | CLIENT MERGE SORT |
> |     PARALLEL INNER-JOIN TABLE 0 |
> |         CLIENT PARALLEL 1-WAY FULL SCAN OVER ORDER1 |
> |     DYNAMIC SERVER FILTER BY ITEMID BETWEEN MIN/MAX OF (O.:ITEMID) |
> +------------+
>
> Please anyone help me understand this explain plan, What is this CLIENT and
> SERVER, I am not able to figure out.
>
>
> Thanks and Regards,
> Komal Ravindra Thombare
>
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you

Mime
View raw message