Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Mon, 27 Jul 2015 23:22:05 +0000 (UTC)
From: "Deneche A. Hakim (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12841137.1435456029000.302213.1438039325617@Atlassian.JIRA>
In-Reply-To: <JIRA.12841137.1435456029000@Atlassian.JIRA>
References: <JIRA.12841137.1435456029000@Atlassian.JIRA>
 <JIRA.12841137.1435456029311@arcas>
Subject: [jira] [Commented] (DRILL-3412) Projections are not getting push
 down below Window operator
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/DRILL-3412?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1464=
3600#comment-14643600 ]=20

Deneche A. Hakim commented on DRILL-3412:
-----------------------------------------

I tried multiple commits, the commit right before 3304 didn't have this iss=
ue but 3304 did. I may be mistaken as I tried lot's of commits building the=
m each time.

> Projections are not getting push down below Window operator
> -----------------------------------------------------------
>
>                 Key: DRILL-3412
>                 URL: https://issues.apache.org/jira/browse/DRILL-3412
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Aman Sinha
>            Assignee: Jinfeng Ni
>            Priority: Blocker
>              Labels: window_function
>             Fix For: 1.2.0
>
>
> The plan below shows that the 'star' column is being produced by the Scan=
 and subsequent Project.  This indicates projection pushdown is not working=
 as desired when window function is present.  The query produces correct re=
sults.
> {code}
> explain plan for select min(n_nationkey) over (partition by n_regionkey) =
from cp.`tpch/nation.parquet` ;
> 00-00    Screen
> 00-01      Project(EXPR$0=3D[$0])
> 00-02        Project(w0$o0=3D[$3])
> 00-03          Window(window#0=3D[window(partition {2} order by [] range =
between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [MIN($1)])])
> 00-04            SelectionVectorRemover
> 00-05              Sort(sort0=3D[$2], dir0=3D[ASC])
> 00-06                Project(T1=C2=A6=C2=A6*=3D[$0], n_nationkey=3D[$1], =
n_regionkey=3D[$2])
> 00-07                  Scan(groupscan=3D[ParquetGroupScan [entries=3D[Rea=
dEntryWithPath [path=3Dclasspath:/tpch/nation.parquet]], selectionRoot=3D/t=
pch/nation.parquet, numFiles=3D1, columns=3D[`*`]]])
> {code}


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)