[
https://issues.apache.org/jira/browse/DRILL-4320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15130181#comment-15130181
]
Khurram Faraaz commented on DRILL-4320:
---------------------------------------
I can repro on mapr Drill 1.5.0 git.commit.id=6a36a704 and JDK8 and MapR FS
5.0.0 on 4 node cluster on CentOS
> 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)
