[jira] [Updated] (DRILL-3412) Projections are not getting push down below Window operator
[
https://issues.apache.org/jira/browse/DRILL-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jinfeng Ni updated DRILL-3412:
--
Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni)
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: Sean Hsuan-Yi Chu
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 results.
{code}
explain plan for select min(n_nationkey) over (partition by n_regionkey) from
cp.`tpch/nation.parquet` ;
00-00Screen
00-01 Project(EXPR$0=[$0])
00-02Project(w0$o0=[$3])
00-03 Window(window#0=[window(partition {2} order by [] range
between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [MIN($1)])])
00-04SelectionVectorRemover
00-05 Sort(sort0=[$2], dir0=[ASC])
00-06Project(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)
[jira] [Updated] (DRILL-3412) Projections are not getting push down below Window operator
[
https://issues.apache.org/jira/browse/DRILL-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Deneche A. Hakim updated DRILL-3412:
Labels: window_function (was: )
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 results.
{code}
explain plan for select min(n_nationkey) over (partition by n_regionkey) from
cp.`tpch/nation.parquet` ;
00-00Screen
00-01 Project(EXPR$0=[$0])
00-02Project(w0$o0=[$3])
00-03 Window(window#0=[window(partition {2} order by [] range
between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [MIN($1)])])
00-04SelectionVectorRemover
00-05 Sort(sort0=[$2], dir0=[ASC])
00-06Project(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)
[jira] [Updated] (DRILL-3412) Projections are not getting push down below Window operator
[
https://issues.apache.org/jira/browse/DRILL-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Victoria Markman updated DRILL-3412:
Priority: Blocker (was: Major)
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-00Screen
00-01 Project(EXPR$0=[$0])
00-02Project(w0$o0=[$3])
00-03 Window(window#0=[window(partition {2} order by [] range
between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [MIN($1)])])
00-04SelectionVectorRemover
00-05 Sort(sort0=[$2], dir0=[ASC])
00-06Project(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)
