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)
