phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Understand explain plan
Date Tue, 25 Nov 2014 02:31:24 GMT
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