drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4320) Difference in query plan on JDK8 for window function query
Date Wed, 03 Feb 2016 10:13:39 GMT

    [ 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)

Mime
View raw message