[jira] [Created] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

["Andries Engelbrecht (JIRA)" <ji...@apache.org>]

Andries Engelbrecht created DRILL-1752:
------------------------------------------

             Summary: Drill cluster returns error when querying Mongo shards on an unsharded collection
                 Key: DRILL-1752
                 URL: https://issues.apache.org/jira/browse/DRILL-1752
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - MongoDB
    Affects Versions: 0.6.0
         Environment: Drill cluster on nodes with Mongo Shards
            Reporter: Andries Engelbrecht


Query fails on a large unsharded collection in MongoDB sharded cluster with drillbits on each node with Mongo shards.

Error message:
0: jdbc:drill:se0:5181> select * from unshard limit 2;
Query failed: Failure while setting up query. Incoming endpoints 1 is greater than number of chunks 0 [cb2121f7-eb3e-48cd-8530-474ca76c598d]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)

0: jdbc:drill:se0:5181> explain plan for select * from unshard limit 2;
+------------+------------+
|    text    |    json    |
+------------+------------+
| 00-00    Screen
00-01      SelectionVectorRemover
00-02        Limit(fetch=[2])
00-03          Scan(groupscan=[MongoGroupScan [MongoScanSpec=MongoScanSpec [dbName=review_syn, collectionName=unshard, filters=null], columns=[SchemaPath [`*`]]]])
 | {
  "head" : {
    "version" : 1,
    "generator" : {
      "type" : "ExplainHandler",
      "info" : ""
    },
    "type" : "APACHE_DRILL_PHYSICAL",
    "options" : [ ],
    "queue" : 0,
    "resultMode" : "EXEC"
  },
  "graph" : [ {
    "pop" : "mongo-scan",
    "@id" : 3,
    "mongoScanSpec" : {
      "dbName" : "review_syn",
      "collectionName" : "unshard",
      "filters" : null
    },
    "storage" : {
      "type" : "mongo",
      "connection" : "mongodb://se4.dmz:27017",
      "enabled" : true
    },
    "columns" : [ "`*`" ],
    "cost" : 625000.0
  }, {
    "pop" : "limit",
    "@id" : 2,
    "child" : 3,
    "first" : 0,
    "last" : 2,
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 625000.0
  }, {
    "pop" : "selection-vector-remover",
    "@id" : 1,
    "child" : 2,
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 625000.0
  }, {
    "pop" : "screen",
    "@id" : 0,
    "child" : 1,
    "initialAllocation" : 1000000,
    "maxAllocation" : 10000000000,
    "cost" : 625000.0
  } ]
} |
+------------+------------+



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