Khurram Faraaz created DRILL-4320:
-------------------------------------
Summary: Difference in query plan on JDK8 for window function query
Key: DRILL-4320
URL: https://issues.apache.org/jira/browse/DRILL-4320
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.4.0
Environment: 4 node cluster CentOS
Reporter: Khurram Faraaz
Difference in query plan seen in window function query on JDK8 with below test
environment, the difference being that a Project is missing after the initial
Scan, the new plan looks more optimized. Should we update the expected query
plan or further investigation is required ?
Java 8
MapR Drill 1.4.0 GA
JDK8
MapR FS 5.0.0 GA
Functional/window_functions/optimization/plan/pp_03.sql
{noformat}
Actual plan
00-00 Screen
00-01 Project(EXPR$0=[$0])
00-02 Project($0=[$2])
00-03 Window(window#0=[window(partition {1} order by [] range between
UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING aggs [SUM($0)])])
00-04 SelectionVectorRemover
00-05 Sort(sort0=[$1], dir0=[ASC])
00-06 Scan(groupscan=[ParquetGroupScan
[entries=[ReadEntryWithPath [path=maprfs:///drill/testdata/subqueries/t1]],
selectionRoot=maprfs:/drill/testdata/subqueries/t1, numFiles=1,
usedMetadataFile=false, columns=[`a1`, `c1`]]])
Expected plan
Screen
.*Project.*
.*Project.*
.*Window.*range between UNBOUNDED PRECEDING and UNBOUNDED
FOLLOWING aggs.*
.*SelectionVectorRemover.*
.*Sort.*
.*Project.*
.*Scan.*
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
