Hi Drillers,
I am trying to build 1.2 and when I test the MongoDB-Storage I have
exception because mongo filter is not find the explain plan string.
Anybody has the same issue?
It looks like the test is expecting fields that are not returned by
the "testPhysicalPlan" method. (we may have to change the test to get
more information from the explain plan or look for another string but
do not want to change anything until I understand why test are not
working in master)
One example:
---
11:52:09.212 [Thread-43] WARN d.f.e.p.store.CachingArtifactStore -
Allready removed
de.flapdoodle.embed.process.extract.ImmutableExtractedFileSet@13b13b5d
for PRODUCTION:OS_X:B64, emergency shutdown?
Results :
Failed tests:
TestMongoFilterPushDown.testFilterPushDownIsEqual:30->MongoTestBase.testHelper:74->PlanTestBase.testPhysicalPlan:61
Unable to find expected string "$eq" : 52.17 in plan: {
"head" : {
"version" : 1,
"generator" : {
"type" : "ExplainHandler",
"info" : ""
},
"type" : "APACHE_DRILL_PHYSICAL",
"options" : [ {
"kind" : "LONG",
"type" : "SESSION",
"name" : "planner.width.max_per_node",
"num_val" : 2
} ],
"queue" : 0,
"resultMode" : "EXEC"
},
"graph" : [ {
"pop" : "mongo-scan",
"@id" : 5,
"mongoScanSpec" : {
"dbName" : "employee",
"collectionName" : "empinfo",
"filters" : null
},
"storage" : {
"type" : "mongo",
"connection" : "mongodb://localhost:27017/",
"enabled" : true
},
"columns" : [ "`rating`", "`full_name`" ],
"cost" : 19.0
}, {
"pop" : "project",
"@id" : 4,
"exprs" : [ {
"ref" : "`rating`",
"expr" : "`rating`"
}, {
"ref" : "`full_name`",
"expr" : "`full_name`"
} ],
"child" : 5,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 19.0
}, {
"pop" : "filter",
"@id" : 3,
"child" : 4,
"expr" : "equal(`rating`, 52.17) ",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 2.85
}, {
"pop" : "selection-vector-remover",
"@id" : 2,
"child" : 3,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 2.85
}, {
"pop" : "project",
"@id" : 1,
"exprs" : [ {
"ref" : "`full_name`",
"expr" : "`full_name`"
} ],
"child" : 2,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 2.85
}, {
"pop" : "screen",
"@id" : 0,
"child" : 1,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 2.85
} ]
}!
TestMongoFilterPushDown.testFilterPushDownGreaterThanWithSingleField:52->MongoTestBase.testHelper:74->PlanTestBase.testPhysicalPlan:61
Unable to find expected string "$gt" : 52.17 in plan: {
"head" : {
"version" : 1,
"generator" : {
"type" : "ExplainHandler",
"info" : ""
},
"type" : "APACHE_DRILL_PHYSICAL",
"options" : [ {
"kind" : "LONG",
"type" : "SESSION",
"name" : "planner.width.max_per_node",
"num_val" : 2
} ],
"queue" : 0,
"resultMode" : "EXEC"
},
"graph" : [ {
"pop" : "mongo-scan",
"@id" : 5,
"mongoScanSpec" : {
"dbName" : "employee",
"collectionName" : "empinfo",
"filters" : null
},
"storage" : {
"type" : "mongo",
"connection" : "mongodb://localhost:27017/",
"enabled" : true
},
"columns" : [ "`rating`", "`full_name`" ],
"cost" : 19.0
}, {
"pop" : "project",
"@id" : 4,
"exprs" : [ {
"ref" : "`rating`",
"expr" : "`rating`"
}, {
"ref" : "`full_name`",
"expr" : "`full_name`"
} ],
"child" : 5,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 19.0
}, {
"pop" : "filter",
"@id" : 3,
"child" : 4,
"expr" : "greater_than(`rating`, 52.17) ",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 9.5
}, {
"pop" : "selection-vector-remover",
"@id" : 2,
"child" : 3,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 9.5
}, {
"pop" : "project",
"@id" : 1,
"exprs" : [ {
"ref" : "`full_name`",
"expr" : "`full_name`"
} ],
"child" : 2,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 9.5
}, {
"pop" : "screen",
"@id" : 0,
"child" : 1,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 9.5
} ]
}!
TestMongoFilterPushDown.testFilterPushDownLessThanWithSingleField:41->MongoTestBase.testHelper:74->PlanTestBase.testPhysicalPlan:61
Unable to find expected string "$lt" : 52.17 in plan: {
"head" : {
"version" : 1,
"generator" : {
"type" : "ExplainHandler",
"info" : ""
},
"type" : "APACHE_DRILL_PHYSICAL",
"options" : [ {
"kind" : "LONG",
"type" : "SESSION",
"name" : "planner.width.max_per_node",
"num_val" : 2
} ],
"queue" : 0,
"resultMode" : "EXEC"
},
"graph" : [ {
"pop" : "mongo-scan",
"@id" : 5,
"mongoScanSpec" : {
"dbName" : "employee",
"collectionName" : "empinfo",
"filters" : null
},
"storage" : {
"type" : "mongo",
"connection" : "mongodb://localhost:27017/",
"enabled" : true
},
"columns" : [ "`rating`", "`full_name`" ],
"cost" : 19.0
}, {
"pop" : "project",
"@id" : 4,
"exprs" : [ {
"ref" : "`rating`",
"expr" : "`rating`"
}, {
"ref" : "`full_name`",
"expr" : "`full_name`"
} ],
"child" : 5,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 19.0
}, {
"pop" : "filter",
"@id" : 3,
"child" : 4,
"expr" : "less_than(`rating`, 52.17) ",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 9.5
}, {
"pop" : "selection-vector-remover",
"@id" : 2,
"child" : 3,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 9.5
}, {
"pop" : "project",
"@id" : 1,
"exprs" : [ {
"ref" : "`full_name`",
"expr" : "`full_name`"
} ],
"child" : 2,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 9.5
}, {
"pop" : "screen",
"@id" : 0,
"child" : 1,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 9.5
} ]
}!
Tests run: 12, Failures: 3, Errors: 0, Skipped: 1
---
Regards
Tug
@tgrall
