You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Laurent Goujon (JIRA)" <ji...@apache.org> on 2016/03/03 01:29:18 UTC

[jira] [Commented] (DRILL-4334) tests in TestMongoFilterPushDown fail in Java 8

    [ https://issues.apache.org/jira/browse/DRILL-4334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15176807#comment-15176807 ] 

Laurent Goujon commented on DRILL-4334:
---------------------------------------

The logical plan is different between Java7 and Java8:

Java7 LP:
{noformat}
 DrillProjectRel(full_name=[$1]): rowcount = 2.85, cumulative cost = {38.0 rows, 125.4 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 75
   DrillFilterRel(condition=[=($0, 52.17)]): rowcount = 2.85, cumulative cost = {38.0 rows, 125.4 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 74
     DrillScanRel(table=[[mongo, employee, empinfo]], groupscan=[MongoGroupScan [MongoScanSpec=MongoScanSpec [dbName=employee, collectionName=empinfo, filters=null], columns=[`rating`, `full_name`]]]):  rowcount = 19.0, cumulative cost = {19.0 rows, 38.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 71
{noformat}

Java8 LP:
{noformat}
 DrillProjectRel(full_name=[$1]): rowcount = 2.85, cumulative cost = {38.0 rows, 125.4 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 78
   DrillFilterRel(condition=[=($0, 52.17)]): rowcount = 2.85, cumulative cost = {38.0 rows, 125.4 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 77
     DrillProjectRel(rating=[$1], full_name=[$0]): rowcount = 19.0, cumulative cost = {19.0 rows, 38.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 76
       DrillScanRel(table=[[mongo, employee, empinfo]], groupscan=[MongoGroupScan [MongoScanSpec=MongoScanSpec [dbName=employee, collectionName=empinfo, filters=null], columns=[`rating`, `full_name`]]]): rowcount = 19.0, cumulative cost = {19.0 rows, 38.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 71
{noformat}

Because of the extra DrillProjectRel, the filter is not pushed into the scan.

This is caused by DRILL-4467. Once this one fixed, the test should pass I believe.

> tests in TestMongoFilterPushDown fail in Java 8
> -----------------------------------------------
>
>                 Key: DRILL-4334
>                 URL: https://issues.apache.org/jira/browse/DRILL-4334
>             Project: Apache Drill
>          Issue Type: Sub-task
>          Components: Tools, Build & Test
>    Affects Versions: 1.5.0
>            Reporter: Deneche A. Hakim
>             Fix For: Future
>
>
> All tests in TestMongoFilterPushDown fail in Java8. It looks like the filter is not pushed down to the Mongo storage plugin



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)