Hi Abdel,
Sorry for that. The code flow that I am trying to understand is below
Like in my query::
SELECT SUM(1) AS `COL` FROM mydb.testtable HAVING COUNT(1)>0
Is the Projection broken down to 1) Final record output , 2) Projection on
Aggregation something like that. Please correct me if I am wrong.
----------------------------------------------------
00-00 Screen : rowType = RecordType(INTEGER COL): rowcount = 1.0, cumulative
cost = {62.1 rows, 607.1 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 217
00-01 Project(COL=[$0]) : rowType = RecordType(INTEGER COL): rowcount =
1.0, cumulative cost = {62.0 rows, 607.0 cpu, 0.0 io, 0.0 network, 0.0 memory},
id = 216
00-02 SelectionVectorRemover : rowType = RecordType(INTEGER COL, BIGINT
$f1): rowcount = 1.0, cumulative cost = {62.0 rows, 607.0 cpu, 0.0 io, 0.0
network, 0.0 memory}, id = 215
00-03 Filter(condition=[>($1, 0)]) : rowType = RecordType(INTEGER COL,
BIGINT $f1): rowcount = 1.0, cumulative cost = {61.0 rows, 606.0 cpu, 0.0 io,
0.0 network, 0.0 memory}, id = 214
00-04 StreamAgg(group=[{}], COL=[SUM($0)], agg#1=[COUNT()]) :
rowType = RecordType(INTEGER COL, BIGINT $f1): rowcount = 1.0, cumulative cost
= {60.0 rows, 600.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 213
00-05 Project($f0=[1]) : rowType = RecordType(INTEGER $f0):
rowcount = 20.0, cumulative cost = {40.0 rows, 120.0 cpu, 0.0 io, 0.0 network,
0.0 memory}, id = 212
00-06 Scan(groupscan=[GroupScan [ScanSpec=ScanSpec [tableName=
testtable, filter=null], columns=[`*`]]]) : rowType =
RecordType(VARCHAR(2147483647) Company, VARCHAR(2147483647) Name): rowcount =
20.0, cumulative cost = {20.0 rows, 40.0 cpu, 0.0 io, 0.0 network, 0.0 memory},
id = 211
Thanks,
Sudip
-----Original Message-----
From: Abdel Hakim Deneche [mailto:[email protected]]
Sent: 14 September 2015 PM 08:12
To: [email protected]
Subject: Re: Drill- Query execution plan
Hi Sudip,
Did you include an image in your email ? unfortunately, Drill's mailing list
doesn't allow any attachments, so we are not able to see the image
On Sun, Sep 13, 2015 at 10:51 PM, Sudip Mukherjee <[email protected]>
wrote:
> Hi,
>
> Need some help understanding the below steps of a query execution. The
> below query is broken down in to these steps.
>
> If you could just explain me in short or point to a documentation link
> would be great for me as I am trying to dig into drill code and logics.
>
>
>
> *SELECT SUM(1) AS `COL` FROM mydb.testtable HAVING COUNT(1)>0 [query
> is sent from tableau]*
>
>
>
>
>
>
>
>
>
> Sudip
>
>
> ***************************Legal Disclaimer***************************
> "This communication may contain confidential and privileged material
> for the sole use of the intended recipient. Any unauthorized review,
> use or distribution by others is strictly prohibited. If you have
> received the message by mistake, please advise the sender by reply email and
> delete the message. Thank you."
> **********************************************************************
>
>
--
Abdelhakim Deneche
Software Engineer
<http://www.mapr.com/>
Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
***************************Legal Disclaimer***************************
"This communication may contain confidential and privileged material for the
sole use of the intended recipient. Any unauthorized review, use or distribution
by others is strictly prohibited. If you have received the message by mistake,
please advise the sender by reply email and delete the message. Thank you."
**********************************************************************
