drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tugdual Grall <tugd...@gmail.com>
Subject [MongoDB] - Anybody able to run the tests?
Date Tue, 20 Oct 2015 10:07:32 GMT
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

Mime
View raw message