[
https://issues.apache.org/jira/browse/DRILL-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14637580#comment-14637580
]
Victoria Markman commented on DRILL-3412:
-----------------------------------------
Jinfeng, this bug was reported this morning as a blocking issue for testing.
We are using TPCDS schema. Should we proceed with views on top of TPCDS tables
that project fewer columns ?
> 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
> 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 results.
> {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=[$0])
> 00-02 Project(w0$o0=[$3])
> 00-03 Window(window#0=[window(partition {2} order by [] range
> between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [MIN($1)])])
> 00-04 SelectionVectorRemover
> 00-05 Sort(sort0=[$2], dir0=[ASC])
> 00-06 Project(T1¦¦*=[$0], n_nationkey=[$1], n_regionkey=[$2])
> 00-07 Scan(groupscan=[ParquetGroupScan
> [entries=[ReadEntryWithPath [path=classpath:/tpch/nation.parquet]],
> selectionRoot=/tpch/nation.parquet, numFiles=1, columns=[`*`]]])
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
