[ https://issues.apache.org/jira/browse/DRILL-1752?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jason Altekruse updated DRILL-1752: ----------------------------------- Fix Version/s: 0.9.0 > 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, 0.7.0 > Environment: Drill cluster on nodes with Mongo Shards > Reporter: Andries Engelbrecht > Priority: Minor > Fix For: 0.9.0, Future > > Attachments: DRILL-1752.patch > > > 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)