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